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.