Try
cfif NOT checkit.recordCount
-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Friday, October 15, 2004 9:53 PM
To: CF-Talk
Subject: RE: Laszlo decision to open source pays a dividend
Hi,
How do i find out if a table is empty? Would it be
cfquery
Just realized that you may be looking at a indvidual column.
You can use the len function as in
cfif NOT len(checkit.error_id)
The column is empty
/cfif
if you are checking the table then recordCount is the ticket
cfif NOT checkit.recordCount
The column is empty
/cfif
btw, you dont need the
No I was looking at the whole table. Its a table to report problems to
someone. If there are no problems, or all problems are resolved (doubt it!)
then the table would be empty. So I need to know so I can make a default
message if that happens. The recordcount works.
Thanks
Phil
-Original
3 matches
Mail list logo