hello
I am trying to do the following:
1. user submits payments
2. goes to ipn.cfm
3. query db
4. create doc using cfdocument
5. save in directory
6. email doc to customer
This code works outside of the IPN file when I do general tests, but as soon as
I add it to the IPN file, it doesn't work.
Can the above be accomplised in IPN.cfm?
any suggestions?
Here is a sample of my code:
<!--- get vars to create file name --->
<CFQUERY datasource="#application.dsn#" dbtype="ODBC"
username="#application.dsnUN#" password="#application.dsnPW#" name="getBiz">
select r.companyID, c.companyID, c.companyName, c.companyCity, c.companyState,
r.profileName
from ratings r, companies c
where r.companyID = '#url.ID#'
and r.companyID = c.companyID
</CFQUERY>
<cfdocument filename='#expandPath("/"#\order\pdfs\test1155.pdf' format="PDF"
overwrite="yes" fontembed="yes">
<LINK HREF="stylePDF.css" TYPE="text/css" REL="stylesheet">
<CFQUERY datasource="#application.dsn#" dbtype="ODBC"
username="#application.dsnUN#" password="#application.dsnPW#" name="getBiz">
select *
from ratings
where companyID = '#url.ID#'
</CFQUERY>
<cfoutput query="getBiz">
add text here for pdf
</cfoutput>
</cfdocument>
<cfmail to='[EMAIL PROTECTED]' from='[EMAIL PROTECTED]' subject='Your
rateYourWork.com Order' type="html">
<font face="Arial, Helvetica, sans-serif" size="2"> Thank you for your order.
Your company rating report is attached. <br />
<br />
Thank you for using rateYourWork.com<br />
<br />
<a href="http://www.rateyourwork.com/";><img
src="http://www.rateyourwork.com/images/smart.jpg"; border="0" /></a>
<cfmailparam file='#expandPath("/"#\order\pdfs\test1155.pdf'
type='application/pdf'>
</font></cfmail>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2974
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
![http://www.rateyourwork.com/images/smart.jpg"](http://www.rateyourwork.com/images/smart.jpg"){kind=link}