Thanks, I tried that. It results in: INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) VALUES ('467','Employee Incentive','','') Warning: MS SQL message: Unclosed quotation mark before the character string '467'. (severity 15) in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62
Warning: MS SQL message: Line 1: Incorrect syntax near '467'. (severity 15) in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62 Warning: MS SQL: Query failed in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62 "John Coder" <[EMAIL PROTECTED]> wrote in message 1026782964.2098.1.camel@kaligula">news:1026782964.2098.1.camel@kaligula... > On Mon, 2002-07-15 at 21:01, Salve Tinkerworth wrote: > > Why do I keep getting messages like: > > > > INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) > > VALUES (463,'In and Out','','') > > Warning: MS SQL message: Line 1: Incorrect syntax near '463'. (severity 15) > > in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62 > > > > Warning: MS SQL: Query failed in > > c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62 > > > > for a simple insert like: > > > > $sql2="INSERT INTO OPS > > (CampaignID,[Description],PhoneInventory,URLInventory) VALUES > > ($new_campaignid,'$Description','$PhoneInventory','$URLInventory')"; > > > Try ('$new_campaignid',....) instead > > <snip> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php