>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
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
All -
I am trying to execute an odbc_exec ($sql) command. A code example
is shown below:
$description = "Chris's Place";
$sql = "UPDATE SEARCH_RECORDS SET DESCRIPTION=\"".$description."\"";
// CX is already defined as a datbase connection
$stmt = odbc_prepare(CX, $sql);
if (odbc_execute($stmt
