Maybe you could describe how it's not working, what goes wrong, etc.
On 8/3/07, Torrent Girl <[EMAIL PROTECTED]> wrote:
> 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>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2975
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}