What I'm trying to get:
<cfoutput query="thisLOG" group="groupID" />
#thisCOUNT# emails sent on #thisLOG.emailDATE#
<cfoutput>
#thisLOG.emailADDRESS#<br>
</cfoutput>
</cfoutput>
"thisCOUNT" above would be the number of emails in a particular group
Here's what I want to do in my query - but errors work since everything
isn't included in a scalar function. I'm using SQL Server
SELECT
COUNT(groupID) as thisCOUNT,
emailID,
emailADDRESS,
emailDATE,
groupID
FROM log_email
WHERE emailID = <cfqueryparam value="#trim(url.emailID)#"
cfsqltype="CF_SQL_INTEGER" />
GROUP BY groupID
ORDER BY emailDATE desc
Haven't found a way to correct this yet that works. Suggestions please?
TIA!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322176
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
