[Sqlrelay-discussion] Does PEAR fetchInto work?
Brought to you by:
mused
|
From: Dave S. <dsu...@co...> - 2006-03-10 04:19:09
|
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 |