thank you.it worked a treat. >The parameters to FindNoCase are back-to-front. > >Adrian > >Hi > >I posted a question a few weeks ago regarding looping through form results, >and someone posted the code below for me to try, however no records are >updated when the form is submited. In fact nothing is happening between the ><cfif findnocase(field, '_')> statement. Any pointers? > >Thanks > ><cfloop collection="#form#" item="field"> > <cfif findnocase(field, "_")> > <cfset id = listgetat(field,2,'_')> > <cfset value = form[field]> > <!--- do whatever with id and value---> > <cfquery datasource="#application.dsn#" name="updateProducts"> > Update products > Set price = #value# > WHERE productID = #id# > </cfquery> > > </cfif> ></cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
