2008-05-25, 11:01 AM
I am getting the error below, this I belive is because of the backtick in the filename. how are people dealing with SQL when the string you want to store has a backtick?
Thanks
error:
Thanks
error:
Code:
2008-05-25 22:53:50.312 VERBOSE [1] ReturnToMainMenu()@2
2008-05-25 22:53:50.328 VERBOSE [1] System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression ''/fullscreen "\\Htpc\mp3\C\Carl Perkins\05_Honey_Don't.mp3"', '1', '25/05/2008 10:53:50 p.m.')'.
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 GameZone.CommonUtilities.SQLInsUpd(String SQLQuery) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\CommonUtilities.vb:line 100
at GameZone.GameZone.GameZoneTask.AddTopTen(String media, String FileName, String DisplayFileName, String selectedEmulator, String emulatorexe, String emulatorarg) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\GameZoneTask.vb:line 1080
at GameZone.ProcUtils.Launch(String media, String FileName, String DisplayFileName, String selectedEmulator, String emulatorpath, String emulatorarg, String emulatorExe) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\ProcUtils.vb:line 119
at GameZone.GameZone.GameZoneTask.PreLaunchCheck(String media, String FileName, String DisplayFileName, String selectedEmulator, String emulatorpath, String emulatorarg, String emulatorExe) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\GameZoneTask.vb:line 2981
at GameZone.GameZone.GameZoneTask.Controls_OnKeyDown(KeyEventArgs e) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\GameZoneTask.vb:line 2001
at GameZone.GameZone.GameZoneTask.OnKeyDown(KeyEventArgs e) in H:\GB-PVR\project\GameZone 2.3\GameZone 2.3\GameZone 2.3\GameZoneTask.vb:line 1350
at GBPVRX2.MenuTask.x9006c1ed9ccb79de.OnKeyDown(KeyEventArgs e)
at GBPVRX2.x0061b801bdf12d35.xdae9991ab918b397(Object xdf2e3583f942db7b, KeyEventArgs xc4f45905cb1fc7ba)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(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 GBPVRX2.x0061b801bdf12d35.WndProc(Message& m)
2008-05-25 22:53:51.671 VERBOSE [1] ShowMouse ref=0
2008-05-25 22:53:53.062 VERBOSE [1] Preparing for shutdown
2008-05-25 22:53:53.125 VERBOSE [1] Exiting...