Re: [cobalt-developers] Re: Interbase & PHP on RaQ4

["William L. Thomson Jr." <webmaster@xxxxxxxxxxxxxxxxxxxx>]

Jim,

> php.net website says that interbase in in alpha test.  Does this mean that I should start learning
ASP or pick a new database?  I've used interbase for years on an NT platform, and have been
impressed with speed and reliablilty.

Must pertain to PHP, more than IB.  Some sites that have not been updated refer to IB 6 as being
beta, but this has not been the case for almost a year.  ASP does work perfectly with IB, although
it is ODBC driver dependent.  I still have not found a good way to use JDBC drivers in ASP.  I use
both ODBC and JDBC connections to IB 6.

All is well here.

As for your other problem, IB version of string quotes are '  so a " would be represented by ' " '
and so on.  I have some insert statements with certain column entries that have several pairs of '
between the ,  .  Make sense.

Good luck, hope that helps.

Sincerely,
William L. Thomson Jr.
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone/fax 707.766.8989
http://www.obsidian-studios.com





----- Original Message -----
From: "Jim Poe" <jpoe@xxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Tuesday, March 13, 2001 6:32 AM
Subject: [cobalt-developers] Re: Interbase & PHP on RaQ4


> Still can't get it to work.
> I've tried every combination of quotes, double quotes, etc that I can think of.  Should have
explained that the data to be posted is coming from a form and is passed in via the form POST
method.  This is what PHPINFO() reports:
> HTTP_POST_VARS["form"] Array
> (
>     [dealerid] => 01811
>     [name] => JFPoe Inc
>     [address1] => 153 Creekside Ln.
>     [address2] =>
>     [city] => Winchester
>     [state] => VA
>     [zip] => 22602
>     [country] =>
>     [phone] => 555-1212
>     [fax] =>
>     [email] =>
>     [webaddress] =>
>     [prodline] => H
> )
> I can use the ibase_query to do the update and it works fine except when there is a quote in the
name or address.  Then I get an UNKNOWN FIELD error from interbase.  If there is a way around that -
I don't need the Prepare/Execute senario.
>
> Have tried testing with only one field but still does not work.
> The following code:
>    $name = "JFPoe Inc.";
>    $qrystr = "update dealer set name=? where dealerid='01811'";
>    $prepared= ibase_prepare($conn, $qrystr);
>    echo $qrystr;
>    echo "<br>";
>    echo "ibase_execute($prepared,\"$name\") <br>";
>   $completed=ibase_execute($prepared,"$name");
>
>   echo "<br>";
>
>   $iberror = ibase_errmsg();
>   if (!($iberror == ''))
>     {
>     echo "$iberror <br>";
>     }
>
> causes the following to display - but only if I place a phpinfo(); before the ibase_execute.
>
> update dealer set name=? where dealerid='01811'
> update dealer set name=? where dealerid='01811'
> ibase_execute(Resource id #3,"JFPoe Inc.")
>

>   _______________________________________________ cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx http://list.cobalt.com/mailman/listinfo/cobalt-developers
>
>