I MESSED UP ON THE PREVIOUS POST, THE BELOW CODE IS THE VALID ONE:
<cfxml variable="myXML">
<Customers>
<cfloop query="ExcelDSN">
<Customer>
<CustomerSource SourceID="NL" SourceType="Purchased" />
<SourceType>SourceType #ExcelDSN.sourcetype#</SourceType>
<Name>#ExcelDSN.Name#</Name>
<EveningPhone>#ExcelDSN.Phone#</EveningPhone>
<Address1>#ExcelDSN.Address1#</Address1>
<Address2>#ExcelDSN.Address2#</Address2>
<City>#ExcelDSN.City#</City>
<State>State #ExcelDSN.State#</State>
<Zip>Zip #ExcelDSN.Zip#</Zip>
</Customer>
</cfloop>
</Customers>
</cfxml>
<cfset XMLPath = Expandpath("./")>
<cffile action="read" file="#XMLPath#in.xslt" variable="xslDoc">
<cfset transformedXML = XmlTransform(myXML, xslDoc)>
<cffile action="write" file="#XMLPath#myXML.xml" output="#transformedXML#">
<cfhttp method="POST" url="https://www.mysite.com/"; resolveurl="True">
<cfhttpparam file="#XMLPath#myXML.xml" name="myXMLPost" type="file">
<!--- Roger's suggestion --->
<cfhttpparam name="param1" value="#transformedXML#" type="XML">
<cfhttpparam type="Header" name="Accept-Encoding" value="deflate;q=0">
<cfhttpparam type="Header" name="TE" value="deflate;q=0">
</cfhttp>
THANKS AGAIN IN ADVANCE TO EVERYONE... PHILLIP & ROGER ESPECIALLY!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197616
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
