View Full Version : What's wrong with this insert statement?

08-17-2005, 07:05 AM
clientcode = integer
product = string
quantity = integer
dateorder = string
price = integer

"insert into orderinvent ([clientcode], [product], [quantity], [dateorder], [price]) values (1,'BluSkies',1,'2005/08/17',20)"

08-17-2005, 09:30 AM
this one too, can you help me? it says update syntax error, i dont know why
p2 is a string while code is a number

set vanny = server.createobject("adodb.recordset")
sql = "UPDATE purchase SET password ='" & p2 & "' WHERE clientcode=" & code

tnx in advance

08-17-2005, 09:16 PM
Add this line between your sql = ".." and cone.execute line:
Response.Write "<p>sql = " & sql & "</p>" & vbcrlf Then paste what gets written to the screen here for us to see. Off the top of my head without seeing what values you are submitting, you might want to check for ' in your strings. If you don't escape an apostophe, you'll get an error.