Hi all

I'm building an SQL query where in addition to the results returned I also 
need to build a list containing the column names which contain values 
and excludes columns which have null values in that recordset.

AFAIK the Columnlist variable returns all the columns by default.

Anyone have a quick solution?

Tristram Charnley

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to