RE: [PHP-WIN] SQL & PHP

2001-05-16 Thread Svensson, B.A.T.
>Why does the command: > >UPDATE SEARCH_RECORDS SET DESCRIPTION="Chris's Page" > >fail? Probably because you have quoted identifiers turned on, turn it off, and it will probably work for you. If you are using MS SQL server add the following statement to your SQL batch to turn off quoted identif

Re: [PHP-WIN] SQL & PHP

2001-05-16 Thread Bradley Miller
At 01:01 PM 5/16/01 -0400, [EMAIL PROTECTED] wrote: >Why does the command: > >UPDATE SEARCH_RECORDS SET DESCRIPTION="Chris's Page" > >fail? You might check that -- I think this will work: UPDATE SEARCH_RECORDS SET DESCRIPTION='Chris''s Page' Bradley Miller, Programmer/webmaster AccessZone De