Subject RE: [firebird-php] echo resultin sql
Author Darren
Thanks Nigel i got the offending line i wish i could say that i know why
it gets the numeric overflow but alas. You get Numeric overflows usually
because the inserted data is bigger than the field value specified
right?
On Thu, 2005-08-11 at 17:17 +1000, Nigel Weeks wrote:
> Yep, I mucked the example. Should be...
>
> >
> > // Prepare/Execute Method
> > <?php
> > $conn =
> ibase_connect("server:/path/to/db.fdb","sysdba","masterkey");
> > $prep = ibase_prepare("SELECT henry, jones FROM BLAH");
> > // $prep now contains the resource ID of the prepared
> > statement, NOT the
> > query string
> >
> > $rec = ibase_execute($prep);
> > // $rec now contains a result set pointer (This had $obj)
> >
> > $obj = ibase_fetch_object($rec);
> > // $obj now contains an object of values from your query
> >
> > echo $obj->HENRY.$obj->JONES;
> > // We just echoed out the contents of the two values
> > ?>
> >
>
>
>
> SPONSORED LINKS
> Inventory database
> software
> Resume database
> software
> Database management
> software
> Oracle database
> software
> Database software
> Database design
> software
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-php" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>