what's the record count for teh query notify_list? Is it 3 also?
----- Original Message -----
From: "Chris Giminez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 28, 2000 2:13 PM
Subject: looping through a mailing list
> This is for a real estate web site where the realtor will add their own
property. When new property
> is added, I want it to check a data table of subscribers who are
interested in a property fitting
> certain criteria, such as price, number of bedrooms, bathrooms, etc.
>
> I thought I had this figured out, but am not getting the desired results.
>
> Here's my code:
> ******************
> <!--- Get the list of subscribers who wich to be notified. --->
> <CFQUERY NAME="notify_list" DATASOURCE="kane">
> SELECT *
> FROM notify
> ORDER BY date_subscribed
> </CFQUERY>
>
> <!--- Loop through the subscribers --->
> <cfloop QUERY="notify_list">
>
> <!--- Check the desires of the subscriber against the actual values of the
property. --->
> <cfif
> form.bed gte notify_list.des_bed
> AND
> form.bath gte notify_list.des_bed
> AND
> form.garage gte notify_list.des_garage
> AND
> form.price gte notify_list.gt_price
> AND
> form.price lte notify_list.lt_price
> AND
> form.sq_ft gte notify_list.des_sq_ft
> AND
> notify_list.des_city CONTAINS form.city
> AND
> form.display eq 1
> AND
> form.status eq "for sale"
> >
> <!--- Send email if the cfif evaluates true <cfmail block will go here
when it's working right. --->
> Send email to <cfoutput query="notify_list">#notify_list.first_name#
> #notify_list.last_name#</cfoutput><br>
> <cfelse>
>
> <!--- Don't send email if cfif evaluates to false. cfelse is only here for
testing now. --->
>
>
> Don't send email <cfoutput query="notify_list">#notify_list.first_name#
> #notify_list.last_name#</cfoutput><br>
>
> </cfif>
>
> </cfloop>
> **********************
>
> I currently have just 3 subscrbers in the notify table for testing and the
above code gives me this
> result.
>
> *****************
> Send email to joe testerTest PersonChris Giminez
> Don't send email joe testerTest PersonChris Giminez
> Don't send email joe testerTest PersonChris Giminez
> *****************
> It's somehow evaluating to true and false for each person.
>
> I know I'm close to getting this. If someone could enlighten me I would be
most grateful.
>
> Thanks!
>
> Chris Giminez
> Owner - Cyber Scriber Web Site Design
> 831-728-4469
> ICQ# 2628000
>
>
>
> --------------------------------------------------------------------------
----
> 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.
