Hello all,
I was wondering if anybody knew of a quick and easy way to retrieve a list
of columns from a specific table.
Currently here are the two methods that I've used.
1.<cfquery name=qry>select * from table</cfquery> #qry.ColumnList#
This is the first method that I used, then I realized that I shouldn't
really do a select * just to get a column list so I went to method 2.
2.<cfquery name=meth2>select count(*) where 1=2</cfquery>#meth2.ColumnList#
I'd like to think that this query is faster because it counts* instead of
selecting* but I don't know for sure which is faster. I just figured that
the record set is larger in number 1 so this one should theoretically be
faster.
Does anybody know of a faster method?
Eric
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
