Well, I was looking for a simple function which could give me the query results in form of a list, I only had one Column Selected
<cfquery name="get_data" datasource="testDsn">
select date from table1
</cfquery>
what is was looking for was just I can do <cfset list = QueryToList(get_data.date)> and I found that there is already a coldfusion function "valueList" to do the same. So to get the list from above you can simply do
<cfset list = valueList(get_data.date)>
really helpful.
Tuesday, March 24, 2009
Subscribe to:
Post Comments (Atom)
Blog Archive
-
►
2007
(18)
-
►
July
(8)
- Searching on Google, Really Cool stuff !!!!!
- Jazz, Two Months Old !!!!!!
- FRIENDS All Seasons Download Links !!!!!!!!
- Output Query To CSV file using Coldfusion MX and J...
- How to Parse XML using Coldfusion MX
- How to Output Query In Excel Format Using Coldfusi...
- SQL Server Interview Questions
- ASP.Net Interview Questions
-
►
July
(8)
0 comments:
Post a Comment