[PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread Salve Tinkerworth
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

Re: [PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread John Coder
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

Re: [PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread Salve Tinkerworth
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