I am currently using ColdFusion MX v7.0 (I know it is dated but actually is working well for my purposes and is pretty stable). I am a "newbie" so please be patient, if I ask obvious questions or request simple clarification. I have gone through the Salesforce.com Web-To-Lead feature they offer and for HTML <form> it works without flaw. However, I need to use <CFFORM> because I not only need to send the form data to Salesforce.com but also to another .cfm page that uses <CFINSERT> into our own database. Upon "submit", I pass the data from the <CFFORM> to a page called insert.cfm. After all my reading, I believe I should use the <CFHTTP> tag and then of course the <CFHTTPPARAM> tag. So my first question, am I correct that this is how I should pass the <CFFORM> data to Salesforce.com? If so, this is what I have done but the data is not getting into Salesforce.com. It is however getting into my database. It is a long form so I'll just show the obvious:
<!--- Begin Insert Section ---> <html> <head> <!--- Begin Variables to be posted to Salesforce.com at this URL ---> <cfhttp url="https://www.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8"; method="post" resolveurl="Yes"> <cfhttpparam type="FORMFIELD" name="FirstName" value="#form.FirstName#"> <cfhttpparam type="URL" value="cfhttp" name="Test1"> </cfhttp> <input type=hidden name="oid" value="00D500000007A2e"> <!--- End Variables to be posted to Salesforce.com at this URL ---> <CFINSERT DATASOURCE="MyDatabase" TABLENAME="Subscribers"> <!--- End Insert Section ---> <!--- Send the message to yourself, when the user posts it on your site. ---> <CFMAIL to="[email protected]" from="#form.Email#" Subject="New User Requests Information from My Company, Inc.!" type="html"> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> New User Requests Information from My Company, Inc.!<br> <br> <strong>#form.CompanyName#</strong><br> #form.FirstName# #form.LastName# - #form.Title# <br> #form.Address#<br> #form.City#, #form.StateProv# #form.StateProv2# #form.Zip#<br> #form.Country# <br> #form.Phone# <br> Any help would be greatly appreciated. I am not getting any errors but the data is not getting into Salesforce.com either. Salesforce.com generated : url="https://www.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8"; as well as the: <input type=hidden name="oid" value="00D500000007A2e"> Thank you in advance. Sifu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
