error en delette.. no lo :ojotes:

rashid · #1 (**permalink**) 20/03/2003, 10:19

este es mi delette

delSQL = delSQL & " delette from auctions were ItemID='"& SQLVal(iItemID)&"'"
GobjConnect.Execute delSQL

y el response.write me tira

delete from auctions were ItemID=22

el error es:
You have an error in your SQL syntax near 'were ItemID=22' at line 1

porke?

ximex · #2 (**permalink**) 20/03/2003, 10:49

delSQL = delSQL & " delette from auctions where ItemID='" & SQLVal(iItemID) & "'"

No sera por que es where y no were?????

rashid · #3 (**permalink**) 20/03/2003, 10:50

faltaba parentesis
GobjConnect.Execute(delSQL)

Don Graff · #4 (**permalink**) 21/03/2003, 08:16

deleTT e...we re

no son delete y where...