Notice: With the launch of Adobe Cookbooks, this site will no longer be accepting new entries or posting new content. Thanks to everyone who submitted content!

Queries

This category discusses how to work with queries as ColdFusion data structures.

Problems

How can I access a query column if I have the column name stored in a variable?
Use structure notation to access the recordset: Keep in mind that with this notation you need...

How do I access one row in a query?
You can access elements of a query result set with array notation: This will give you the val...

How do I get the values from one column in a query?
If you need to retrieve the values from one column in a query, ColdFusion provides the valueList() f...

How do I re-sort a query?
If you have a database query that is not sorted, or is sorted by the wrong column, you may have a ne...