Hi Peter
Thanks worked a treat!
Jason
> 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:318910
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4