EasyCFM.COM ColdFusion Forums / Tutorial Requests! / query mailing

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: query mailing

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

ned57
02-20-2007 @ 8:54 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 90
Joined: Aug 2006

right i need to create a query where the result pulls out data that is more than 12 months old. this bit is simple, but the tricky part come when from each record, the person gets an automated message stating that something you entered is more than 12 months old. is there a way to do this.

thanks

_____________________
I LOVE THE IMPOSSIBLE

CJ
02-20-2007 @ 1:10 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4262
Joined: Oct 2002

right well if you got the query part then what's so tricky about using <cfmail>?

-CJ-
@ #coldfusion/DALNet
http://charlie.griefer.com

Teachers open the door. You enter by yourself.
—Chinese Proverb

ned57
02-21-2007 @ 8:07 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 90
Joined: Aug 2006

sorry i explained it wrong, i am struggling on the query part to pull out records that are more than 12 months old. can someone help me on that. thanks

_____________________
I LOVE THE IMPOSSIBLE

CJ
02-21-2007 @ 11:43 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4262
Joined: Oct 2002

WHERE (your date column name here) < <cfqueryparam value="#dateAdd('m', -12, now())#" cfsqltype="cf_sql_timestamp">

(this really should be in the coding help section, btw, no?)

-CJ-
@ #coldfusion/DALNet
http://charlie.griefer.com

Teachers open the door. You enter by yourself.
—Chinese Proverb

ned57
02-22-2007 @ 4:24 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 90
Joined: Aug 2006

thanks, and i searched for this on the site but wass unable to locate it. thanks again

_____________________
I LOVE THE IMPOSSIBLE

tati2001
01-31-2013 @ 2:02 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Member
Posts:
Joined: Dec 2012

How you can control sending emails.
for example i have database 10k and because of mail server can not accept more than 500email in 30min,
how i can control sending flow for my CFMAIL

any help ?


thanks

Tarko


Website Designed and Developed by Pablo Varando.