You can treat the form name as a list and use the listgetat() (use '_' as the delimiter) to get the various parts of the string.
On Wed, Apr 2, 2008 at 9:23 AM, Sehlmeyer, Jason <[EMAIL PROTECTED]> wrote: > Wondering if anyone can help me out. First off, what I'm trying to do > is grab a list of IDs (via query) then grab an amount of time they've > performed X job and submit that as a variable along with the date. No > big deal, I can do that. > > > > What I want on the submission page, is to take that variable which is > passed and extract the date, the type of pay, and the ID, then update a > different table with the value using those three things as parts of the > insert. > > > > For instance, by query I get IDs of 1000 1001 1004, etc. > > <input type="hidden" > name="#Trim(Resource_ID)#_Reg_#DateFormat(i,'mm_dd_yyyy')#" > value="#hours#"/> > > > > As you can see I'm using the underscore to separate the different parts > of the variable name being passed. > > > > So my Update will be something like > > > > INSERT INTO table #Resource_ID#, Reg, #DateFormat(mm_dd_yyyy, > 'mm/dd/yyyy')#, #hours# > > > > My problem is trying to get each individual piece from the variable > submitted. > > > > Again, I have multiple variables for each ID as there are multiple days > submitted, and I also have multiple IDs I need to add. > > > > I'm sure this is very confusing which is why I'm probably going at this > the wrong way. > > > > Any thoughts? > > > > Thanks, > > Jason > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4