I'm suprised that query[column] ever worked. I thought that regardless of the recordcount it would always require query[column][row]!!
Ade -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 25 March 2005 19:33 To: CF-Talk Subject: RE: Non simple values in a query record set? Follow Up: Running through all the is...() functions, I get an Yes from isArray(). For some reason, CF is thinking this value is an array, but not the value in the previous row. SOLVED: Ok, found the error. This was interesting. I was copying data from one record set to another with the following code. <cfif CPS_data.recordCount> <!--- If there was a match in the hours query, copy the hours data to the drives query. ---> <cfloop list="#CPS_data.columnlist#" index="CPS_col"> <cfset querySetCell(Drives,CPS_col,CPS_data[CPS_col][1])> </cfloop> <cfelse> Orginally I did not have the [1] row declaration since the CPS_data recordset could only have one row in it. This apparently caused the value to copyied over as some kind of "array" value. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200038 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
