Error message - Expected end of statement

[eyal]

Hi,
Everytime I run the page I get the following Error message - Expected end of statement

conord.Execute "insert into orders (itemnum, itemname, quantity, price, total) values ('" "key" & "','" & "name" & "','" & "quant" & "','" & "pric" & "','" & "midtotal" & "')"

Any idea?
Thanks
Eyal
[sig][/sig]

 

[montek]

Create a local variable, like SQL, to hold the SQL statement. That way, you print it out after you build it to make sure it's correct. There might be something strange going on. Ex:

SQL="insert into orders (itemnum, itemname, quantity, price, total) values ('" "key" & "','" & "name" & "','" & "quant" & "','" & "pric" & "','" & "midtotal" & "')"

conord.Execute(SQL)

[sig]<p>Monte Kalisch<br><a href=mailto:montek@montekcs.com>montek@montekcs.com</a><br><a href=

http://www.brainbench.com>Brainbench.com

MVP for ASP</a><br> [/sig]