I just ran into some of these issues when I had to write an IPN a few weeks back. Mine does almost everything yours is doing - so I know it can be done. (I also log and save a duplicate of the PayPal transaction into my website db so I don't always have to hop back and forth between sites.)
I learned a lot from this tutorial: http://tutorial23.easycfm.com/ First - try the forums under your sandbox PayPal account - great resource for any specific questions you may have. They were very helpful to me and people respond quickly to your posts. Second - try to view your IPN.cfm directly from the website - and see if you get any errors. You should - but you should probably only get the "Element FIELDNAMES is UnDefined in Form." (Because you are not receiving form data from PayPal.) Any other errors will probably show up here which will help you out. (Quick way to find typos, etc) Third - Setup a log file and track where your IPN is breaking. This was very helpful for me. Basically - I placed <cftry> around all the different parts with a catch like: <cfcatch> <!--- let's log all errors ---> <cffile action="append" file="E:\YOURSITE\paypal_logs\paypal_log.txt" output="Error entering cart items: #cfcatch.message# #cfcatch.detail# :: #Now()#"> </cfcatch> Fourth - Probably a good idea to setup some <cflocks> as well. Fifth - Are you using a PDT.cfm file as well? And do you have the IPN setup/turned on in your PayPal account? Hope that helps! - Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2983 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
