> You could do
>
> <CFIF check_email.RecordCount EQ 0>
> Didn't work
> <CFELSE>
> Worked, run this code
> </CFIF>
That works brilliantly - thanks!
Will
>
>
> ----- 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.
>
------------------------------------------------------------------------------
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.
