This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Please Check the syntax for me. I can't find any error by myself. But I always get an error report, say Insert into syntax is wrong. BTW, this happens when I uploaded the page. It works well on PWS.sqlstring=" INSERT INTO groupcust ("&_
"username,password) VALUES ("&_
" ' '"&fixquotes(gusername)&"',' "&fixquotes(newpassword)&"' )"
Con.Execute sqlstring
Note:fixquotes is a function I defined. It works well.
Thank you for your help.
-waokool(waokool);
2002-9-6
{260}
(#731491@0)
-
SQL Server or Oracle?If the function "fixquotes" returns a string, try to not use the signale quote surrounding it. And are "gusername" and "newpassword" varible, if they are variable, you probably need to write a stored procedure to include the varible definition and assignment.
-freshair(Happy pig);
2002-9-6
{265}
(#732011@0)
-
you didn;t handle single quote in your function. So when the return value username has a ' in the string, Oracle or SQL raise an error.
-ningxin0809(菊扇);
2002-9-6
(#732019@0)