Re: Dynamic Form

[Peter Boughton]

You need to start by not doing this:
        <cfif IsDefined("form.wp_select#Evaluate(LoopCount)#")>
        <cfset variables.wp_select="form.wp_select#Evaluate(LoopCount)#">
        <cfset variables.wp_select="#Evaluate(variables.wp_select)#">
        <cfelse>
        <cfset variables.wp_select="no">
        </cfif>

Use bracket notation instead of the convoluted evaluate stuff.

Something like this might do what you want:
    <cfif StructKeyExists(Form,'wp_select#LoopCount#')>
        <cfset variables.wp_select = form['wp_select#LoopCount#'] />

        <cfquery name=”insert_del” datasource=”#application.dsn#”>
            INSERT INTO del_cost (del_cost)
            VALUES (<cfqueryparam value="#form['wp_delivery_cost#LoopCount#']#" 
cfsqltype="cf_sql_integer">)
        </cfquery>

    </cfif>


(If that doesn't make sense, hopefully someone else can come along and improve 
on the answer, because unfortunately I have to go sleep.)




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318908
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4