Since you are only doing ONE grouping, that is all you will get in
return:
Try this:
<cfoutput query="gettrial" group="email1">
#name# -- <cfoutput>#email1#</cfoutput> <br>
</cfoutput>
-----Original Message-----
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 12:49 PM
To: CF-Talk
Subject: Only one record
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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
