myles@... wrote:

> I am running Firebird 1.5 Super Server on a Windows 2000 box with
> Apache/PHP4. When trying to enter text data into a Firebird database, I

ah missed that on the first read thru. php4 support for firebird is
er, shit (MHO). If you want decent firebird support in php you'll need to
upgrade to php5.

> have specific stored procedures that handle the updating of various tables.
> Text data that contains a single quote character in it (ie. O'Connell, etc.)
> is causing errors in Firebird when executing the query. This is typically
> due to the fact that I put quotes around the text fields in order to send
> them as a arguments to the stored procedures.
>
> What is the best practice way of handling fields with single quote
> characters purposely entered into them, and getting this data into Firebird?

$sql = "EXECUTE PROCEDURE sp_myproc(?,?,?)"; // sql to call
$res = ibase_query($dbconn, $sql, "O'connel", "\"''\\'", "");

>
> Myles
>
>
> ============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions US, Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> www.techsol.org
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>