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]
- failing when query is named. Daniel Kessler
- Re: failing when query is named. Mystic
- RE: failing when query is named. J E VanOver
- RE: failing when query is named. Philip Arnold
- RE: failing when query is named. Greg Luce
- RE: failing when query is named. Jerry Johnson
- RE: failing when query is named. Dave Watts
- RE: failing when query is named. Pascal Peters
- failing when query is named. Daniel Kessler
- RE: failing when query is named. Andre Turrettini