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...