You can do a CFIF statement:
<cfif (QueryName.Recordset)>
Do stuff here
<cfelse>
Do something else
</cfif>
Also, you do not need to loop through and put the query results in an array.
You can just cfoutput the information:
<cfoutput query="queryname" Name = "Name">
Output information goes here
</cfoutput>
Or, you can do a cfloop with the query attribute.
<cfloop query=-"Queryname">
Output information goes here
</cfloop>
HTH
Bruce
----- Original Message -----
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 2:56 PM
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
