DELETE i MySQL
Jeg kan simpelthen ikke få denne DELETE i MySQL til at virke - hva\' er der galt?Min SQL-streng ser sådan ud:
strSQL=\"DELETE * FROM bookmark where bookmark_url = \'\" & tmpURL & \"\' AND bookmark_email=\'\" & tmpEmail & \"\'\"
Min kommando:
Set SearchCMD = Server.CreateObject(\"ADODB.Command\")
SearchCMD.ActiveConnection = SearchDB
SearchCMD.CommandType=1
SearchCMD.CommandTimeout=40
SearchCMD.CommandText=strSQL
SearchCMD.Execute
Serveren svarer:
Microsoft OLE DB Provider for ODBC Drivers error \'80040e09\'
[TCX][MyODBC]You have an error in your SQL syntax near \'* FROM bookmark where bookmark_url = \'http://www.akupunkturklinikken.dk/\' AND bo\' at line 1
/global/bookmark/bookmark_delete.asp, line 28
Linje 28:
SearchCMD.Execute
