Look into using <cfstorecontent> to grab the table into a variable.
Then you only have to make one urlencodedformat() call on it.
--Ben Doom
john mcdonald wrote:
> 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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292167
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
