RE: Dynamic Form Selects and Posting Troubles

2006-03-17 Thread PINE Phyo Z
Hi Mark, Sorry for replying late. I just got a chance to go over the CF-Talk posts. I don't know whether I understand your problem right or not. But probably using Arrays (or Structs) might solve your problem? I would do something like this when calling CFC: It would look like A15

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
ark > > -Original Message- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 11:27 AM > To: CF-Talk > Subject: RE: Dynamic Form Selects and Posting Troubles > > Let me make sure I understand. You have a set of arguments >

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Mark Leder
TED] Sent: Thursday, March 16, 2006 11:27 AM To: CF-Talk Subject: RE: Dynamic Form Selects and Posting Troubles 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

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
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, be

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Mark Leder
UPDATE #SESSION.companyInfo.companyTablePrefix#_Users_List_UserModulesPermissions SET permissionID = WHERE userID = AND moduleID = Thanks, Mark -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, March 16, 2006 10:28 AM To: CF-Talk Subject: RE: Dynamic Fo

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
> 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

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Mark Leder
om: 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

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Munson, Jacob
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 ARGU

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Mark Leder
rk -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

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Munson, Jacob
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 Lede