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

[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 Message-----
  From: Duane Boudreau [mailto:[EMAIL PROTECTED]
  Sent: Friday, October 15, 2004 10:12 PM
  To: CF-Talk
  Subject: RE: table is empty WAS: Laszlo decision to open source pays a
dividend

  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 ## inside the cfif statement

  Duane

    -----Original Message-----
    From: Duane Boudreau [mailto:[EMAIL PROTECTED]
    Sent: Friday, October 15, 2004 10:01 PM
    To: CF-Talk
    Subject: RE: table is empty WAS: Laszlo decision to open source pays a
  dividend

    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 datasource="#mydbname#" name="checkit">
        SELECT *
        FROM error_table
        </cfquery>
        <cfoutput query="checkit">
        <cfif #error_id# IS " "><!---or would that be NULL?--->
        The Table Is Null!
        </cfif>
        </cfoutput>

      or is that wrong?

      Thanks Phil

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---