Re: looping through a mailing list
How many properties do you have in the database? - Original Message - From: Chris Giminez <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 29, 2000 3:31 PM Subject: Re: looping through a mailing list > I've changed part of the checking to the query, not cfif's, but I am still getting the same wrong > results. I could really use some help if someone can, or at least a nudge in the right direction. > > *** > > SELECT * > FROM notify > > Where > 0=0 > AND > #form.bed# >= des_bed > AND > #form.bath# >= des_bath > AND > #form.garage# >= des_garage > AND > #form.price# >= gt_price > AND > #form.price# <= lt_price > AND > #form.sq_ft# >= des_sq_ft > > ORDER BY date_subscribed > > > > > > > notify_list.des_city CONTAINS form.city > AND > form.display eq 1 > AND > form.status eq "for sale" > > > > > Send email to #notify_list.first_name# > #notify_list.last_name# > > > > > > > Don't send email #notify_list.first_name# > #notify_list.last_name# > > > > > *** > > Thanks! > > Chris Giminez > Owner - Cyber Scriber Web Site Design > 831-728-4469 > ICQ# 2628000 > > > > > > Yer wasting a lot of processing power in coldfusion unnecessarily. You > > should build a where clause that replicates the conditions you are searchinf > > for in your CFIF, that way you just loop over the result set and send the > > email to every single record. SQL Will handle that much faster than Cold > > Fusion will. > > > > Jordon > > > > > > > > > > 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: > > ** > > > > > > SELECT * > > FROM notify > > ORDER BY date_subscribed > > > > > > > > > > > > > > > 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 to #notify_list.first_name# > > #notify_list.last_name# > > > > > > > > > > > > Don't send email #notify_list.first_name# > > #notify_list.last_name# > > > > > > > > > > ** > > > > 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. > > > > -- > 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.
Re: looping through a mailing list
I've changed part of the checking to the query, not cfif's, but I am still getting the same wrong results. I could really use some help if someone can, or at least a nudge in the right direction. *** SELECT * FROM notify Where 0=0 AND #form.bed# >= des_bed AND #form.bath# >= des_bath AND #form.garage# >= des_garage AND #form.price# >= gt_price AND #form.price# <= lt_price AND #form.sq_ft# >= des_sq_ft ORDER BY date_subscribed Send email to #notify_list.first_name# #notify_list.last_name# Don't send email #notify_list.first_name# #notify_list.last_name# *** Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 > Yer wasting a lot of processing power in coldfusion unnecessarily. You > should build a where clause that replicates the conditions you are searchinf > for in your CFIF, that way you just loop over the result set and send the > email to every single record. SQL Will handle that much faster than Cold > Fusion will. > > Jordon > > > > 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: > ** > > > SELECT * > FROM notify > ORDER BY date_subscribed > > > > > > > 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 to #notify_list.first_name# > #notify_list.last_name# > > > > > > Don't send email #notify_list.first_name# > #notify_list.last_name# > > > > > ** > > 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. > -- 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.
RE: looping through a mailing list
Yer wasting a lot of processing power in coldfusion unnecessarily. You should build a where clause that replicates the conditions you are searchinf for in your CFIF, that way you just loop over the result set and send the email to every single record. SQL Will handle that much faster than Cold Fusion will. Jordon -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 1:40 PM To: [EMAIL PROTECTED] 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: ** SELECT * FROM notify ORDER BY date_subscribed Send email to #notify_list.first_name# #notify_list.last_name# Don't send email #notify_list.first_name# #notify_list.last_name# ** 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.
Re: looping through a mailing list
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: > ** > > > SELECT * > FROM notify > ORDER BY date_subscribed > > > > > > > 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 to #notify_list.first_name# > #notify_list.last_name# > > > > > > Don't send email #notify_list.first_name# > #notify_list.last_name# > > > > > ** > > 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.
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: ** SELECT * FROM notify ORDER BY date_subscribed Send email to #notify_list.first_name# #notify_list.last_name# Don't send email #notify_list.first_name# #notify_list.last_name# ** 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.
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: ** SELECT * FROM notify ORDER BY date_subscribed Send email to #notify_list.first_name# #notify_list.last_name# Don't send email #notify_list.first_name# #notify_list.last_name# ** 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.