Any recommendations? I have no problems changing what I've already done. Using ListGetAt() was my first guess, as I could use the '_' as the delimiter, but how would I know what each variable name is that's submitted?
That's the biggest part I'm confused as to what to do. i.e. cfdump gives me: 10421_REGULAR_03_09_2008 0.0 10421_REGULAR_03_10_2008 2.0 10421_REGULAR_03_11_2008 3.0 10421_REGULAR_03_12_2008 3.0 10421_REGULAR_03_13_2008 3.0 10421_REGULAR_03_14_2008 3.0 I was thinking using something similar to: #ListGetAt(form,1,'_')# But that gives me an error due to complex object type: Complex object types cannot be converted to simple values Jason [EMAIL PROTECTED] -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 10:31 AM To: CF-Talk Subject: RE: Variable problems 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:302491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
