Shawn- Here is rough page code based on what I have done in the past. First: Insert your data into your table. I use standard SQL insert code instead of cfinsert - I find that it works better for me (YMMV) Second: post your data to the web-to-lead form Third: make sure you are passing all the fields that SFDC requires for assignment. If you don't pass them, the insert may fail.
Feel free to let me know if you have any questions. /Scott BELOW IS THE CONTENT OF "Insert2q.cfm" <!--- insert to database code goes here ---> <cfquery name="insertData" dataSource="TestDBAll"> INSERT SQL CODE HERE </cfquery> <!--- this is the sfdc processing for ALL fields inserting to SFDC ---> <cfhttp method="Post" url="http://www.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8";> <!------------------ This HTML is defaulted to DEBUG mode so that your web master can test the online Web-to-Lead page from the desktop. Once your web master has finished testing please remember to remove the entire "debug" and "debugEmail" lines of code prior to adding this HTML to your website. -------------------> <!--- <input type="hidden" name="debug" value=1> <input type="hidden" name="debugEmail" value="[email protected]">---> <!--- <cfhttpparam type="Formfield" value="1" name="debug"> <cfhttpparam type="Formfield" value="[email protected]" name="debugEmail"> ---> <cfhttpparam type="Formfield" value="what_ever_your_SFDC_code_is" name="Campaign_ID"> <!--- your specific SFDC account Code ---> <cfhttpparam type="Formfield" value="00D500000007A2e" name="oid"> <!--- THE FIELDS FOR SFDC these will change based on your form fields ---> <cfhttpparam type="Formfield" value="#FORM.first_name#" name="first_name"> <cfhttpparam type="Formfield" value="#FORM.last_name#" name="last_name"> <!--- Job function role ---> <cfhttpparam type="Formfield" value="#FORM.job_title#" name="title"> <!--- Job function ---> <cfhttpparam type="Formfield" value="#FORM.company_name#" name="company"> <cfhttpparam type="Formfield" value="#FORM.address_1# #FORM.address_1#" name="street"> <cfhttpparam type="Formfield" value="#FORM.email#" name="email"> <cfhttpparam type="Formfield" value="#FORM.state_province#" name="state"> <cfhttpparam type="Formfield" value="#FORM.country#" name="country"> <cfhttpparam type="Formfield" value="#FORM.postal#" name="zip"> <cfhttpparam type="Formfield" value="#FORM.phone#" name="phone"> <cfhttpparam type="Formfield" value="#FORM.fax#" name="fax"> <cfhttpparam type="Formfield" value="#FORM.annual_revenues#" name="revenue"> <cfhttpparam type="Formfield" value="#FORM.employees#" name="employees"> <cfhttpparam type="Formfield" value="#FORM.industry#" name="industry"> <!--- Solution of interest---> <cfhttpparam type="Formfield" value="#FORM.interest#" name="what_ever_your_custom_SFDC_code_is "> <cfhttpparam type="Formfield" value="#FORM.role#" name="what_ever_your_custom_SFDC_code_is"> <cfhttpparam type="Formfield" value="#FORM.jobfunction#" name="what_ever_your_custom_SFDC_code_is"> <!--- Timeframe ---> <cfhttpparam type="Formfield" value="#FORM.time_frame#" name="what_ever_your_custom_SFDC_code_is"> <!---LANGUAGE ---> <cfhttpparam type="Formfield" value="#FORM.language#" name="what_ever_your_custom_SFDC_code_is"> <cfhttpparam type="Formfield" value="#FORM.refered_by#" name="what_ever_your_custom_SFDC_code_is"> <!--- newsletter ---> <cfhttpparam type="Formfield" name="member_status" value="Registered"> <cfhttpparam type="Formfield" name="lead_source" value="web"> <cfhttpparam type="Formfield" name="Campaign_ID" value="what_ever_your_custom_SFDC_code_is"> <cfhttpparam type="Formfield" value="#FORM.contact_staus#" name="what_ever_your_custom_SFDC_code_is"> </cfhttp> <!--- Browser display (presentation) code here ---> <h2>Thanks!</h2> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
