I have two queries. One gets the trial expiration date for today in the
trials_info dbase.
The other Select takes the trial name (dynamic as #get.name#) and searches for
the trial in the trials datasource and then grabs the email registrants in this
trial and emails them. I use an embedded Select for the trial.
This works, believe it or not, to the degree that it only displays the first
record on the
<cfoutput query="gettrial" group="email1">#name# - #email#<br></cfoutput> query
as:
cc_test -- [EMAIL PROTECTED]
cc_test -- [EMAIL PROTECTED]
I need it to loop through all. The first Select finds the two records. I tried
CFLOPP, but I'm not a proficient CF progrtammer and can only do this
occasionally because of my other "responsibilities".
Any help appreciated...as always. Thanks.
RO
HWW
<cfquery name="Get" datasource="trials">
Select * from trials_info
where expiration = '#DateFormat(now()),"mm/dd/yyyy")#'
</cfquery>
<cfquery name="Gettrial" datasource="trials">
Select email1 from #get.name# where exists (Select * from trials_info
where expiration = '#DateFormat(dateAdd(now()),"mm/dd/yyyy")#')
group by email1
</cfquery>
<P><hr>
<cfoutput query="gettrial" group="email1">#name# -- #email1#<br></cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
