Select top 1 * so that only one row is returned. You don't want to return the entire table.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Scott OConnell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 11:25 PM To: sql Subject: Re: SQL Query to count the number of columns >SQl Query to count(find) the number of columns present in a table() Select * in a query called "Results" Then: ListLen(Results.columnList) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3153 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
