You could do
<CFIF check_email.RecordCount EQ 0>
Didn't work
<CFELSE>
Worked, run this code
</CFIF>
----- Original Message -----
From: "WL" <[EMAIL PROTECTED]>
To: "Cold Fusion Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 06, 2000 8:33 AM
Subject: very basic IF problems - newbie
> Hi,
>
> I'm new to CF (PHP programmer) - can someone please explain to me a simple
> CFIF thing I need
> to do. I have a form-page which submits data to an action page. The
first
> query is as follows:
>
> <cfquery name="check_email" datasource="localads">
>
> SELECT first_name,last_name,email FROM members WHERE email =
'#form.email#'
>
> </cfquery>
>
> I then need to do this kind of thing "If this Query returns TRUE, run the
> next block of code...if it's FALSE, then just exit" - but how?
>
> Thanks a lot in advance
>
> Will
>
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
