Did you try Salesforce.cfc? http://salesforcecfc.riaforge.org
Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer ____________ http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 6/28/2011 9:02 PM, Shawn Contreras wrote: > 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:345883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
