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. Thanks, Mark -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 5:41 PM To: CF-Talk Subject: RE: Dynamic Form Selects and Posting Troubles 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:235498 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
