Thanks to everyone for your replies. I have acutually done a little on this.
Setting up the email to a DB of users has turned out to be easier than I
realized. The challenge is that I am also including dynamically-generated
content in the email. In order to do this I am doing a table join between a
membership table and a content table. In the content table are a bunch of
articles and each article has a date property assigned to it. What I am
tring to accomplish is to grab the articles for that week in a query and put
the info in the email. So, how do I use the Date function to create
situation like:
<cfset todays_date = #Dateformat(Now(), "mm/dd/yyyy")>
<cfset endofweek_date #Dateformat(Now +4(), "mm/dd/yyyy")>
Select stuff, from members,content
where content_date BETWEEN todays_date and endofweek_date
Ideas?
Thanks
George Loch
------------------------------------------------------------------------------
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.
