CFMX 7.0.2: Query Object Missing with Empty Informix Record Set

Related Categories: ColdFusion

I had a customer last week report he applied hot fix 64430 to CFMX 7.0.2 and started getting variable undefined errors for queryname.recordCount for empty Informix record sets. I confirmed the debug output shows a valid query with recordcount=0; but CF throws undefined variable/object errors if you try to output any of the query variables (recordCount, currentRow, or columnList).

This issue occurred when using the IBM Informix v2.11 drivers with CFMX 7.0.2 hf702_64430. It does not occur when using the IBM Informix v3.0 drivers or the bundled DataDirect Informix driver.

I created technote 8704413c for this issue which should be published shortly. See technote tn_19171 for instructions on configuring the IBM JDBC driver.

Comments (1) | Print | Send | del.icio.us | Digg It! | Linking Blogs

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

[Add Comment] [Subscribe to Comments]

I am having a similar problem using a SQL 2000 server. Any updates or fixes to this?

# Posted By Alan | 4/10/07 7:22 AM

[Add Comment]