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?
> -----Original Message----- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 15, 2006 3:24 PM > > Now, I can't seem to figure out how to loop for 3 records, > and match up the > FORM.A155 with the db record of 155 in order to update the > permission level > (1 thru 5). It's the SET that's the problem. Notice that the > ARGUMENTS.a101 could be any number from A101 to A160. I can > find which > three numbers are being updated from the qPermissionCount recordset. > > <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="#ARGUMENTS.A101#"> > > WHERE userID = <cfqueryparam cfsqltype="cf_sql_char" > value="#ARGUMENTS.userID#"> > AND moduleID = <cfqueryparam cfsqltype="cf_sql_integer" > value="#qPermissionCount.moduleID#"> > </cfif> > </cfquery> 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. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235495 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
