ColdFusion query variables

queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList

Comments

qateef said on Aug 9, 2003 at 10:09 PM :

I am getting lost. These are not new variables!. is not avaliable on prviouse version?

No screen name said on Aug 12, 2004 at 12:34 PM :

Is there a way to iterate through all the fields of a row without using dynamic expressions?

No screen name said on Aug 12, 2004 at 12:50 PM :

Also, is it possible to return the fields in ColumnList in the order that they appear in the table instead of alphabetically?

halL said on Aug 17, 2004 at 3:01 PM :

In response to the two messges of Aug. 12, 2004:
The columnlist variable always contains the column names in alphabetical order.
For the question on iterating over the columns of a row without using a dynamic expression,
I would recommend that you pose your question to the ColdFusion Forums: http://webforums.macromedia.com/coldfusion/.

Siefemel said on Aug 25, 2004 at 8:08 AM :

If using MSSQL you can use the stored procedure sp_columns to get the column names in order they appear in the database. So, you are forced to hit the schema separately if you want to do that. I think in a CFMX update a field name and value array should be built in like in the ADODB.Recordset object I use in ASP.