Problem with special-characters in SQL-statements

Bug reports for an official AniDB Client go here

Moderators: AniDB, AniDB API

Locked
kidan
Posts: 319
Joined: Thu Feb 13, 2003 9:13 pm
Location: .DE

Problem with special-characters in SQL-statements

Post by kidan »

I think some special-characters should be 'escaped' (like ; ) to be sql-conform.


Sorry, German output:

Informationen über das Aufrufen von JIT-Debuggen
finden Sie am Ende dieser Meldung, anstatt in diesem Dialogfeld.

************** Ausnametext **************
System.Data.OleDb.OleDbException: Syntaxfehler (fehlender Operator) in Abfrageausdruck '"Perfect Blue (US sub) "Director`s Cut" ;-)",other="" WHERE id=66017'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Anidbclienttest3.db.noquery(String line)
at Anidbclienttest3.db.parsemylist(StreamReader input)
at Anidbclienttest3.netfile.update(String url, Boolean drop)
at Anidbclienttest3.net.getdiffnfo()
at Anidbclienttest3.net.getnetupdate()
at Anidbclienttest3.Form1.menuItem2_Click(Object sender, EventArgs e)
at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
at System.Windows.Forms.MenuItemData.Execute()
at System.Windows.Forms.Command.Invoke()
at System.Windows.Forms.Control.WmCommand(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Geladene Assemblys **************
mscorlib
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/microsoft.net/framework/v1.0.3705/mscorlib.dll
----------------------------------------
Anidbclienttest3
Assembly-Version: 1.0.1262.37582
Win32-Version: 1.0.1262.37582
CodeBase: file:///C:/Dokumente%20und%20Einstellungen/Jan/Desktop/anidbclient/Anidbclienttest3.exe
----------------------------------------
System.Windows.Forms
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.3300.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system/1.0.3300.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.3300.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System.Data
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.3300.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Xml
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.3300.0__b77a5c561934e089/system.xml.dll
----------------------------------------
System.EnterpriseServices
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3705.288
CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.3300.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
----------------------------------------
ICSharpCode.SharpZipLib
Assembly-Version: 0.5.0.0
Win32-Version: 0.5.0.0
CodeBase: file:///C:/Dokumente%20und%20Einstellungen/Jan/Desktop/anidbclient/ICSharpCode.SharpZipLib.DLL
----------------------------------------
System.resources
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3300.0
CodeBase: file:///c:/windows/assembly/gac/system.resources/1.0.3300.0_de_b77a5c561934e089/system.resources.dll
----------------------------------------
System.Windows.Forms.resources
Assembly-Version: 1.0.3300.0
Win32-Version: 1.0.3300.0
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms.resources/1.0.3300.0_de_b77a5c561934e089/system.windows.forms.resources.dll
----------------------------------------

************** JIT-Debuggen **************
Um das JIT-Debuggen (Just-In-Time) zu aktivieren, muss in der
Konfigurationsdatei der Anwendung oder des Computers
(machine.config) der jitDebugging-Wert im Abschnitt system.windows.forms festgelegt werden.
Die Anwendung muss mit aktiviertem Debuggen kompiliert werden.

Zum Beispiel:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

Wenn das JIT-Debuggen aktiviert ist, werden alle nicht behandelten
Ausnahmen an den JIT-Debugger gesendet, der auf dem
Computer registriert ist, und nicht von diesem Dialogfeld behandelt.
Hisoka
Posts: 11
Joined: Fri May 30, 2003 9:25 am
Location: Berlin - Germany

Post by Hisoka »

jep got that will change in next version thanx

Cya
Hisoka[]
kidan
Posts: 319
Joined: Thu Feb 13, 2003 9:13 pm
Location: .DE

Post by kidan »

Hi, is there a new version ready soon? As right now I cannot test the client any further without removing Perfect Blue from my Mylist.
Locked