Subject | RE: [firebird-php] echo resultin sql |
---|---|
Author | Alan McDonald |
Post date | 2005-08-11T09:58:21Z |
> Thanks Nigel i got the offending line i wish i could say that i know whyor maybe the precision trying to be stored exceeds the precision of the
> it gets the numeric overflow but alas. You get Numeric overflows usually
> because the inserted data is bigger than the field value specified
> right?
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
> > > ?>
> > >