'0' is returned, or should be.
Better to do the old logic check
<cfif #xy.RecordCount#>
<!--- I've got some records --->
<cfelse>
<!--- Theres No records --->
</cfif>
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2000 15:40
To: CF-Talk
Subject: What is xy.recordcount ?
Hi List, I have a query (xy) where I want to make a cfif-question on
xy.recordcount.
What would xy.recordcount be if xy.recordcount would throw no record ?
I assumed "0". But it seems to be somehow undefined.
Ideas why and what it is ?
Should I prefer the "Count"-Statement from SQL for this ?
Uwe
Mail: [EMAIL PROTECTED]
Web: www.sdsolutions.de
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
###################################################
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]
####################################################
##################################################
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
