Try:

<cfif check_email.RecordCount GT 0>
  <!--- Other Code here --->
</cfif>

Russel Madere, Jr.
Web Developer

"Be good and you will be lonesome.
 Be lonesome and you will be free.
 Live a lie and you will live to regret it."
                          Jimmy Buffett
                          That's What Living Is To Me
-----Original Message-----
From: WL [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 06, 2000 10:34 AM
To: Cold Fusion Talk
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.

Reply via email to