<html>
<font size=3>Incorrect. This one bit me a while back. If the query does
not return any rows it is 'undefined' and the code below will cause an
error.<br>
<br>
There is a difference between a query that returns 0 rows and a query
that does not return a recordset.<br>
<br>
At 11:34 AM 11/27/00 -0500, Todd Ashworth wrote:<br>
<blockquote type=cite cite>You don't really need to specify any
numbers. If the query returns any<br>
rows, then it's true. If it returns none, it is false. So,
this would<br>
suffice:<br>
<br>
<cfif xy.RecordCount><br>
True<br>
<cfelse><br>
False<br>
</cfif><br>
<br>
Todd Ashworth<br>
<br>
----- Original Message -----<br>
From: <[EMAIL PROTECTED]><br>
To: "CF-Talk" <[EMAIL PROTECTED]><br>
Sent: Monday, November 27, 2000 10:40 AM<br>
Subject: What is xy.recordcount ?<br>
<br>
<br>
| Hi List, I have a query (xy) where I want to make a cfif-question
on<br>
| xy.recordcount.<br>
| What would xy.recordcount be if xy.recordcount would throw no record
?<br>
| I assumed "0". But it seems to be somehow undefined.<br>
| Ideas why and what it is ?<br>
| Should I prefer the "Count"-Statement from SQL for this
?<br>
|<br>
| Uwe<br>
|<br>
| Mail: [EMAIL PROTECTED]<br>
| Web:
<a href="http://www.sdsolutions.de/" eudora="autourl">www.sdsolutions.de</a><br>
<br>
<br>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
Structure your ColdFusion code with Fusebox. Get the official book at
<a href="http://www.fusionauthority.com/bkinfo.cfm"
eudora="autourl">http://www.fusionauthority.com/bkinfo.cfm</a><br>
<br>
Archives:
<a href="http://www.mail-archive.com/[email protected]/"
eudora="autourl">http://www.mail-archive.com/[email protected]/</a><br>
Unsubscribe:
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists</a>
</font></blockquote><br>
<font size=3><br>
---------------------------------------------------------------------------<br>
Peter Theobald, Chief Technology Officer<br>
LiquidStreaming <a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
[EMAIL PROTECTED]<br>
Phone 1.212.545.1232 x204 Fax 1.212.545.0938<br>
<br>
To put this contact information into your Palm device, click here:<br>
<a
href="http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A"
eudora="autourl">http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A<br>
<br>
</a></font></html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
