Hi Everyone,
I've been trying to solve this for a couple hours, and am getting nowhere fast.
If anyone here as an idea that could point me in the right direction I would be
very grateful.
I have this HTML table which is being output to the users browser, and its got
data from several queries in it. (see below for the table) and it works fine to
output normally, but what I need to do is URL encode the entire table (After
its been rendered with the data from the queries) and stuff the whole thing
into a form variable that I can pass into Lotus Notes using a <cfhttp
method="Post">
The table (with query data) will then be unencoded by Lotus Notes and displayed
as part of an email that will be sent to whoever. The whole passing into Lotus
Notes part works fine. I have a rendered, hard coded, URL Encoded string as
part of a <cfhttp method="Post"> that I used for testing and works fine. I just
don't know how to URL encode the table with the query values on the fly in my
code so I can stuff it into the form field value.
<table width="664" border="1" cellpadding="5" cellspacing="0"
bordercolor="#CCCCCC">
<tbody>
<tr >
<td width="462" bgcolor="#CCCCCC" ><h2 align="center"
class="style1">Question</h2></td>
<td width="196" bgcolor="#CCCCCC" ><h2 align="center"
class="style1">Answer</h2></td>
</tr>
<tr >
<td>Product Market Segment</td>
<td><strong><cfif
isDefined("pnums.MARKETSEGMENTS")><cfoutput>#pnums.MARKETSEGMENTS#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td>Quarterly Forecasted Revenue</td>
<td><strong><cfif
isDefined("totalEC")><cfoutput>#dollarformat(totalEC)#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td>Quarterly Forecasted Quantity</td>
<td width="196"><strong><cfif
isDefined("getParts.qtrlyFcstQty")><cfoutput>#getParts.qtrlyFcstQty#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td>Quarterly Forecasted G Margin</td>
<td ><strong><cfif
isDefined("metaFinance.SH_FIN_GROSSMARGIN")><cfoutput>#metaFinance.SH_FIN_GROSSMARGIN#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td>Minimum Pull Quantity</td>
<td width="196" ><strong><cfif
isDefined("metaHubMgt.SH_JHM_MINPULLQTY")><cfoutput>#metaHubMgt.SH_JHM_MINPULLQTY#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td>Cost Per Unit for ______ pulls</td>
<td width="196" >
<p><strong>Min Pull QTY:</strong> <cfif
isDefined("metaHubMgt.SH_JHM_minPullQty")><cfoutput>#metaHubMgt.SH_JHM_minPullQty#</cfoutput></cfif>
</p>
<p><strong>Cost Per Pallet:</strong> <cfif
isDefined("metaHubMgt.SH_JHM_costPerUnitPallPull")><cfoutput>#metaHubMgt.SH_JHM_costPerUnitPallPull#</cfoutput></cfif></p>
<p><strong>Cost Per Carton:</strong> <cfif
isDefined("metaHubMgt.SH_JHM_costPerUnitCartPull")><cfoutput>#metaHubMgt.SH_JHM_costPerUnitCartPull#</cfoutput></cfif></p>
<p><strong>Cost Per Layer:</strong> <cfif
isDefined("metaHubMgt.SH_JHM_costPerUnitLayPull")><cfoutput>#metaHubMgt.SH_JHM_costPerUnitLayPull#</cfoutput></cfif></p>
</td>
</tr>
<tr >
<td>Adder</td>
<td width="196" ><strong><cfif
isDefined("metapricing.SH_PRI_ADDER")><cfoutput>#metapricing.SH_PRI_ADDER#</cfoutput></cfif></strong></td>
</tr>
<tr >
<td><p class="style2">Stakeholder - Does Not Qualify & Comments</p>
</td>
<td width="196" ><cfinclude template="Q-doesNotQualify.cfm"></td>
</tr>
<tr >
<td>Hub Justification</td>
<td width="196"><strong><cfif
isDefined("metaRequest.REQ_HUBJUST")><cfoutput>#metaRequest.REQ_HUBJUST#</cfoutput></cfif></strong></td>
</tr>
</tbody>
</table>
Any ideas would be greatly appreciated.
Thanks
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292161
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
