...

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



lovesirius12
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)"

lovesirius12
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
cone.execute(sql)

tnx in advance

neocool00
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum