I am not sure what exactly you are trying to do but you access specific
parts of the query output by using this syntax:
queryname.columnname[rownumber]
If you want to get all data from specific column in a query and convert it
into a long string (say comma delimited), you need to loop over a query
like this:
<cfset temp = "">
<cfoutput query="pivot_values">
<cfset temp = temp & pivot_values.yourCoulmnName & ",">
</cfoutput>
There might be easier way to do this but I cannot think of it now.
TK
-----Original Message-----
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 2:18 PM
To: CF-Talk
Subject: Getting a value from a query
I'm trying to assign a value from a query column like so:
<cfoutput query="pivot_values">
<cfset temp = pivot_values["#attributes.pivot#"]>
</cfoutput>
I then want to manipulate this value as a string. But when I do the
above statement, cf is treating temp as a reference instead of the
actual value. I've tried using toString, but it complains that a
complex value cannot be used in the function. How can I get to the value?
--
marlon
[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Getting a value from a query Marlon Moyer
- RE: Getting a value from a query Barney Boisvert
- RE: Getting a value from a query Tom Kitta
- RE: Getting a value from a query Tony Weeg