RE: table is empty WAS: Laszlo decision to open source pays a dividend

2004-10-15 Thread Duane Boudreau
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

RE: table is empty WAS: Laszlo decision to open source pays a dividend

2004-10-15 Thread Duane Boudreau
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

RE: table is empty WAS: Laszlo decision to open source pays a dividend

2004-10-15 Thread Phillip Perry
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