XTGeminiman
02-17-2005, 11:41 PM
Ok, I've recently migrated my access databases to mysql and I'm having a few problems. One's with the delete script. It worked fine before but for some reason it's not deleting with mysql. I'm getting the following error...
NBA Street V3
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Street V3' at line 1
/releaseerase.asp, line 16
<%
Option Explicit
Dim username,sql,rsdelete, console, game
console = request.querystring("console")
game = request.querystring("game")
username = Request.Cookies("username")
if username = "" then
Response.Redirect("default.asp")
end if
%>
<!--#include file="conn.asp"-->
<%
response.write(game)
conn.Execute("DELETE FROM "& console &"releases WHERE title = " & game & "")
conn.close
set conn = nothing
%>
The querystring works and I've tested the table querystring correctly as well. It doesn't make sense.
NBA Street V3
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Street V3' at line 1
/releaseerase.asp, line 16
<%
Option Explicit
Dim username,sql,rsdelete, console, game
console = request.querystring("console")
game = request.querystring("game")
username = Request.Cookies("username")
if username = "" then
Response.Redirect("default.asp")
end if
%>
<!--#include file="conn.asp"-->
<%
response.write(game)
conn.Execute("DELETE FROM "& console &"releases WHERE title = " & game & "")
conn.close
set conn = nothing
%>
The querystring works and I've tested the table querystring correctly as well. It doesn't make sense.