Re: PHP4/mssql_query INSERT problems
| From: | Salve Tinkerworth | Date: | Tue, 16 Jul 2002 03:22:32 +0000 |
| Subject: | Re: PHP4/mssql_query INSERT problems | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20568@lists.php.net to get a copy of this message | ||
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" <jcoder@insightbb.com> wrote in message
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>
>
>