I recall that in my old Python days working with MySQL, I had to explicitly set a 'read all' bit on the record set so all records would be read from the result stream before I iterated through them. I don't know if this translates into this context.
matt wrote:
Matt, I have run across this with the JDBC plugin talking to an Oracle DB. I found that if only one record was returned, this logic bombed in the exact same manner, the workaround was to set the curRecord pointer to the last and read backwards if the record count ==1. Otherwise you just read records as you have coded. You should verify that the rs begins at the "0" record. Your while condition should be the return value of [rs moveNext]. Martin, The problem is that many records should be returned by this query, however I can only read the first one. The column count is correct, as is the data, however only one row is returned. The data is in the Db, and queries using other s/w work fine, just not the ODBCKit. Thanks, Matt________________________________________________________________ Sent via the WebMail system at youney.com_______________________________________________Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) Please do not post admin requests or moderator comments to the list. Contact the moderators at cocoa-dev-admins(at)lists.apple.com Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/cocoa-dev/mcstoufer%40lbl.gov This email sent to [EMAIL PROTECTED]
-- * Martin C. Stoufer * * ISS/IT * * Lawrence Berkeley National Lab * * 510-486-5306 * * MS 937-700 *
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) Please do not post admin requests or moderator comments to the list. Contact the moderators at cocoa-dev-admins(at)lists.apple.com Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
