My gut says there's a better way to do what you're trying, but to get your version to work, look at the list functions, ListGetAt(), ListLast() etc. with "_" as the delimiter.
Adrian http://www.adrianlynch.co.uk/ -----Original Message----- From: Sehlmeyer, Jason [mailto:[EMAIL PROTECTED] Sent: 02 April 2008 15:24 To: CF-Talk Subject: Variable problems 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:302488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
