|
Subject:
|
Question
|
|
Posted By:
|
Ashwini
|
Post Date:
|
1/5/2006 2:20:11 AM
|
Please help me I have an error In this line
strdml="INSERT INTO order (Id,orderdate,type,comm,disc,consigneename,lcno,date,amount,expdate,buyerorderno,buyerorderdate,currency,remarks,commagent,style,model,deldate,unit)VALUES ('"&Id&"','"&orderdate&"','"&otype&"','"&comm&"','"&disc&"','"&consigneename&"','"&lcno&"','"&ldate&"','"&lamount&"','"&expdate&"','"&buyerorderno&"','"&buyerorderdate&"','"&bcurrency&"','"&remarks&"','"&commagent&"','"&style&"','"&model&"','"&deldate&"','"&unit&"')"
And the error is
Syntax error in INSERT INTO statement.
But the form takes values ,when saw through Response.write strdml
Please help mein this
|
|
Reply By:
|
ChrisScott
|
Reply Date:
|
1/5/2006 4:21:19 AM
|
Which db are you using?
Can you post the output from Response.Write strdml, please?
Cheers,
Chris
|
|
Reply By:
|
Ashwini
|
Reply Date:
|
1/10/2006 4:42:27 AM
|
Please help me why this error comes
My Querry
strdml="INSERT INTO Id (Id,orderdate,type,comm,disc,consigneename,lcno,ldate,lamount,expdate,buyerorderno,buyerorderdate,bcurrency,remarks,commagent,style,model,deldate,unit)values('"&Id&"','"&orderdate&"','"&otype&"','"&comm&"','"&disc&"','"&consigneename&"','"&lcno&"','"&ldate&"','"&lamount&"','"&expdate&"','"&buyerorderno&"','"&buyerorderdate&"','"&bcurrency&"','"&remarks&"','"&commagent&"','"&style&"','"&model&"','"&deldate&"','"&unit&"')"
objcon.Execute strdml
response.write strdml
error is
Data type mismatch in criteria expression.
I am using ms access database
Please help me b'coz I can't go further in my work
|
|
Reply By:
|
ChrisScott
|
Reply Date:
|
1/10/2006 6:20:46 AM
|
In access you need to surround date values with hashes - ... , #" & ldate & "#, ... etc., integer values do not need single quotes around them.
If you still have problems, can you post the output from Response.Write strdml, please?
HTH,
Chris
|
|
