You could do subqueries like so: <cfquery name="marketData" datasource="webdata"> SELECT a.total, b.marketdata FROM (select count(*) as total from main) a, (select count(*) as marketData from main where this_page LIKE 'marketData%') b </cfquery>
But, the better solution would probably be to create a view in your database that does the above query (with all your other stuff), and then select once from the view in CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
