Is there any expedient (preferably no loop) way to get the number of columns in a query result? I'm dealing with a module that uses a data set without knowing its details.
<cfoutput>
#ListLen(YourQuery.ColumnList)#
</cfoutput>
<cfquery name="myQuery" datasource="#dsn#">
SELECT * FROM myTable
</cfquery>
<cfoutput>#myQuery.columnList#</cfoutput>
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With