SQL Syntax error
Posted: Sun Dec 11, 2005 9:10 am
i keep getting this error message:
can anyone help?
this is the code to it:Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft JET Database Engine
Description: Syntax error in INSERT INTO statement.' in c:\Inetpub\wwwroot\Assignment\orderconf.php:59 Stack trace: #0 c:\Inetpub\wwwroot\Assignment\orderconf.php(59): com->Execute('INSERT INTO T_o...') #1 {main} thrown in c:\Inetpub\wwwroot\Assignment\orderconf.php on line 59
Code: Select all
$adoCon->Execute
("INSERT INTO T_order(SesId, Harrier, SixNut, Mount, Nut, Seal312a, Tracking, Wing, Turbine, Injection, Seal, UserId) VALUES ('$Session', $Harrier, $SixNut, $Mount, $Nut, $Seal312, $Track, $Wing, $Turb, $Injection, $Seal, '$User');");