The query attribute of the cfoutput tag accepts a query as its value.

The cfoutput then loops through the query, running one loop of the output, then moving to the next record of the query and running the next loop, until it runs out of records.

If you pass in an empty query (with 0 records), 0 loops are run.

This should do what I think you are trying to do,

<cfquery name="check_registration" datasource="css-cffa-sites">
      SELECT *
      FROM bodyfun_registry
      WHERE userName = '#Form.userName#'
</cfquery>

<cfif check_registration.recordCount gt 0>
       okey, done
<cfelse>
       aw, so messed up
</cfif>

Does this make any sense?
Jerry Johnson

>>> [EMAIL PROTECTED] 03/17/04 03:25PM >>>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to