Scott:
You can determine how many record were returned by a particular query via
the query results set's RecordCount attribute as in:
<CFQUERY NAME="myQuery" ... >
...
</CFQUERY>
<CFOUTPUT>The query returned #myQuery.RecordCount# results.</CFOUTPUT>
You don't need to place the QRS into an array in order to loop over the
results. You can simply use CFOUTPUT as in:
<CFOUTPUT QUERY="myQuery">
#Column1# and #Column2#
</CFOUTPUT>
The above will print out the values of Column1 and Column2 for every record
contained within the "myQuery" result set.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----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
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
