Kevin, how about this scenario?
<cfquery name="query1">
Select count(*) from users where lastname like 'smith%'
</cfquery>
<cfif query1.count gt 500>
Notify users that they have to do a nightly scheduled report.
<cfelse>
/* run a full-on query */
<cfquery name="query2">
Select lastname, firstname, phone, address, blah blah
from users where lastname like 'smith%'
</cfquery>
</cfif>
-----Original Message-----
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 11:59 AM
To: CF-Talk
Subject: RE: CF Test
One... I'm not laughing.
Two... Exactly my point. I can't remember the last time I *only* needed
a
count.
Cheers,
Kevin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216853
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
