Scott, You really need to buy the CF Application Book. In the meantime:
<cfquery name="queryName" datasource="dsn"> SQL goes here </cfquery> queryName.recordCount = number of records You don't need to dump it into an array. You can loop over the query with: <cfoutput query="queryName"> </cfoutput> Good luck with CF. Buy the book. Ben needs the money. (j/k) Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -----Original Message----- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:56 PM To: CF-Talk Subject: Database Results When I used to work with ASP, I would run my SQL statement, check to see if the recordset is empty or not, if it wasn't, I'd roll it up into an array, and the loop through the array. I know how to do the SQL statement, and how to loop through it, but how would I check to see if the result of the query contained results or not, and how would I put the results in an array, and then how would I loop through that array? I'm sorry for asking so many questions...I'm in a new job which is also a new developing environment...and I have very little time to learn all this... Any & all help is greatly appreciated, as I know everyone in here is strapped for time as well. Thanks, Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
