Subject RE: [firebird-php] echo resultin sql
Author Darren
It seems to be importing now for some strange reason i exported data out
again and tried importing back in again and it works! I suspect it was a
precision error for just in case i cleaned up the export program.

On Thu, 2005-08-11 at 19:58 +1000, Alan McDonald wrote:
> > 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?
>
> or maybe the precision trying to be stored exceeds the precision of
> the
> storage element.
> Alan
>
> > 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
> > > > ?>
> > > >
>
>
>
>
> ______________________________________________________________________
> 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.
>
>
> ______________________________________________________________________
>