Hey all,
I have an app that at midnight each day, queries a database and fires of an
email with a .PDF attachment for a ski voucher. The problem is that each person
is getting not only their voucher but the others who registered as well. Here
is what I am doing:
<cfquery datasource="DealsDSN" name="qGetUseremail">
SELECT Name, Address_1, Address_2, City, State, Zip, Email, BarCode,
ACC_Code, BirthDate, Deal_Name, DateRegistered, Time_Registered,
Confirmation_Number
FROM MAH.Users
WHERE DateRegistered = '#DateFormat(Yesterday,"mm/dd/yyyy")#' AND BarCode
IS NOT NULL
</cfquery>
<cfoutput query = "qGetUserEmail">
<cfdocument
name="Voucher"
format="PDF"
pagetype="custom"
pageheight="5"
pagewidth="6.5"
margintop="0"
marginbottom="0"
marginright="0"
marginleft="0"
unit="in"
fontembed="true"
backgroundvisible="true"
localurl="true">
<cfoutput>
Voucher formatting goes here
</cfoutput>
</cfdocument>
<cfmail from="xxxxx" to="#Email#" subject="Voucher Barcode" type="html">
Email message here
<cfmailparam
file="Voucher.pdf"
type="application/pdf"
content="#Voucher#"
/>
</cfmail>
</cfoutput>
When I dump the information I get one row of the users information with X
number of barcodes. What do I need to do to ensure that the intended recipient
only receives their barcode? I am sure it's simple but again, I have been out
of the CF game a while and the obvious is escaping me.
Brue
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354403
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
