You would need to compare the output of each column and then keep only the ones that
have data in them.
Clint
---------- Original Message ----------------------------------
from: "Tristram Charnley" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 18 Sep 2001 10:39:46 +0100
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
