Getting the NumberofColumns in a resultset

Question

So I have a query that creates a table of the data after it is submitted, but the results are dependent upon which SELECT fields the user selects via a checkbox.

Example:

I have 3 checkboxes for 3 different fields in the query: Name, Number, Address. If the user only checks Name and Number, then the SELECT query will be SELECT firstName, number FROM tableofinfo.

So, the resulting table for the results can either be 1, 2 or 3 columns (depending on how many checkboxes they check). My question is, how can I pull the number of fields or columns that the table resulted in so that I can use that for further manipulation? So, for the example it would be 2 (Name and Number). I have the result="resultInfo" set on the <cfquery> tag, and I know that #resultInfo.RecordCount# will give me the number of rows, but I want the number of columns. Is this possible?

Thanks

Dan_Bracuk · Answer

cfquery provides a couple of variables. One of these lists all the columns. The name of that variable is in the cfml reference manual. If you don't have one, google cfquery and you'll find what you want lickety split.

If you don't know what to do with that variable, googling "coldfusion list functions" might give you some ideas.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded