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:235499 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

