On 10/27/06, Peter Tilbrook <[EMAIL PROTECTED]> wrote:
> If a CFQUERY returns no records it does not exist so there is no way to test
> for "zero" records as no result is produced.
>
That's incorrect:
<cfquery datasource="myDS" name="QTest">
SELECT *
FROM sometable
WHERE 1=0
</cfquery>
<cfoutput>#QTest.RecordCount#</cfoutput>
The output is 0. You can get the columnlist too.
--
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258241
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
