Let me make sure I understand. You have a set of arguments passed in, each containing a permission id as their value. You need to set your permissionID in the DB to the value of the passed in arguments using a loop. The problem is that you don't know what the argument names are ahead of time, because they are dynamically created. Am I on the right track? If so, I hope someone else on the list has some ideas, because I'm stumped. :\
> -----Original Message----- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 8:51 AM > > Well we're warm: > > The qPermissionsCount has the moduleID's, in this case 133, 141, 151. > The permissionID should be numeric from 1-5 for each ARGUMENT > that is passed > in, which would be A133, A141, A151. So, thisID needs to > refer to each > ARGUMENTS.A(x) in turn. > > <cfloop index="i" from="1" to="#qPermissionCount.recordcount#"> > <cfset thisId = "A#i#"> > <cfquery name="updOBJ2" datasource="#REQUEST.dsnSQL#" > username="#REQUEST.dsnUID#" password="#REQUEST.dsnPWD#"> > UPDATE > #SESSION.companyInfo.companyTablePrefix#_Users_List_UserModule > sPermissions > SET permissionID = <cfqueryparam cfsqltype="cf_sql_integer" > value="#thisId#"> > WHERE userID = <cfqueryparam cfsqltype="cf_sql_char" > value="#ARGUMENTS.userID#"> > AND moduleID = <cfqueryparam cfsqltype="cf_sql_integer" > value="#qPermissionCount.moduleID#"> > </cfquery> > </cfloop> [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:235543 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
