Sorry I haven't explained this properly. The first time an update occurs, there could be 3 arguments (let's say A133, A150, A120).
The second time an update occurs, there could be 8 arguments (A133, A121, A123, A145, and so on). The ARGUMENTS value that is passed contains a permissionsID, which will always be 1 through 5. The var name of A133 is actually a reference to the actual module ID number contained in the db. So, yes, I am trying to figure out how to have a dynamic var name instead of the fixed ARGUMENTs.A155 using a loop. Thanks, Mark -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 6:46 PM To: CF-Talk Subject: RE: Dynamic Form Selects and Posting Troubles The part that's got me confused is that you say "Notice that the ARGUMENTS.a101 could be any number from A101 to A160." That leads me to believe that you want that variable name to be dynamic, based on the 3 records returned from your other query. But in your code you've got it hard coded to ARGUMENTS.A155 instead of a dynamic variable name. Or is that what you're trying to figure out how to do (the dynamic variable name)? > -----Original Message----- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 15, 2006 4:31 PM > > The ARGUMENTS.a155, etc. are all being passed properly to the CFC. > In this sense the ARGUMENTS.A155 = "3" > > I've got that placed in the "SET permission ID =" because that's that > value I want to update. > Looping the update is where I'm having trouble. > > -----Original Message----- > From: Munson, Jacob > Sent: Wednesday, March 15, 2006 5:41 PM > > I your updOBJ2 query, you are using ARGUMENTS.A101, but I don't see > where that is getting created. It looks like you are dealing with > dynamic variable name problems, but in that query you have the > variable name hard coded. Or am I missing something? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
