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]

Reply via email to