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.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
....-----Original Message-----
....From: Ian Skinner
....Sent: Friday, March 25, 2005 11:19 AM
....To: CF-Talk
....Subject: Non simple values in a query record set?
....
....Here's a fun one.
....
....I have a record set, which is a manual joining of two other record sets,
....using all the general query functions. Somehow, one of the cells in the
....second row of this record set is being read as a complex value? When I
....try to output it, I get the following error. "Complex object types cannot
....be converted to simple values." When I test the value with a
....isSimpleValue() function, it returns "No". The value in the same column
....in the previous row is recognized as simple.
....
....How can this be? Can record sets contain complex values, I would have
....though not. When I dump the record set in question, the failing value is
...."900", I do not see what is complex about that.
....
....If it matters:
....CF 6.1 updater 3
....Win 2000 server.
....
....Anyone got any idea what this is about?
....
....--------------
....Ian Skinner
....Web Programmer
....BloodSource
....www.BloodSource.org
....Sacramento, CA
....
...."C code. C code run. Run code run. Please!"
....- Cynthia Dunning
....
....Confidentiality Notice: This message including any
....attachments is for the sole use of the intended
....recipient(s) and may contain confidential and privileged
....information. Any unauthorized review, use, disclosure or
....distribution is prohibited. If you are not the
....intended recipient, please contact the sender and
....delete any copies of this message.
....
....
....
....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:200036
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
