[Sqlrelay-discussion] Re: Does PEAR fetchInto work?

[Dave S. <dsu...@co...>]

Well, it turns out that it was a problem in the code I was  
integrating SQLRelay into and not a problem with SQLRelay at all.  On  
to figure out the other problems now.

Dave

On 10 Mar, 2006, at 23:14, sqlrelay-discussion- 
re...@li... wrote:

> To: sql...@li...
> From: Dave Sugar <dsu...@co...>
> Date: Thu, 9 Mar 2006 23:19:00 -0500
> Subject: [Sqlrelay-discussion] Does PEAR fetchInto work?
> Reply-To: sql...@li...
>
>
> I'm just getting started with SQlRelay at this point and I'm working
> on retrofitting a website that I have done a lot of work on in the
> past.  It already uses the PHP PEAR DB interfaces for Oracle
> (primarily) but also for MtSQL, MSSQL and some for postgreSQL.
> Anyway there are a lot of calls to things that call the prepare
> function to setup a cursor,  Then call fetchInto to loop through all
> the matched rows.
>
> But what I'm seeing is it is never advancing the cursor
> (DB_sqlrelay_cursor) past the first row (the call is incrementing the
> instance of the cursor), but on the next call to fetchInto it is
> again 0.
>
> I have not done extensive testing with  the problem to be 100% sure
> it isn't my code, but just looking to verify it isn't a known issue.
>
> I'm working with tar download installed from source version 0.37 (not
> CVS version).  PHP 4.3.11
>
> Simple queries (not using perpare) seem to be functioning ok, so
> something is working correctly.
>
> I have a gut feeling there is something wrong in the sqlrelay.php
> file - function 'simpleQuery' where it is returning the new
> DB_sqlrelay_cursor - because it isn't returning a reference - but I
> have no basis for that feeling yet.
>
> Any help greatly appreciated.
> Dave
>