Well, solved kinda... I have worked around the inability to use ODBC to
access my MySQL database by using the MCPkit framework (AKA MySQLCocoa).
This is a very complete library that works well. It does however have the
obvious limitation of being MySQL only.
I would prefer to be using ODBC, and
I am having a problem with the ODBCKit, and a MySQL database.
I really like the design and usage of the ODBCKit, and it is quite easy to use.
There is however quite a serious problem that I cannot get around. When a
recordset is returned, I can only see one record. Attempting to move to
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
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
So we know there are multiple rows in the db that satisfy your query.
Can you verify that multiple rows do show up in the rs object? I find
that the call to rs.moveFirst is a bit redundant and the loop condition
being [rs moveNext]. This assumes that this call does return a BOOL if
successful.
-- Original Message --
From: Jonathan Monroe [EMAIL PROTECTED]
Date: Thu, 28 Aug 2008 12:59:44 -0500
On Aug 28, 2008, at 12:19 PM, [EMAIL PROTECTED] wrote:
I am having a problem with the ODBCKit, and a MySQL database.
I really like the design and