SteveG
Posts: 56
|
| Posted: 02/25/2005, 4:44 PM |
|
I'm trying to custom update a table so that the Previous_Audience_Id field ends up containing the Audience_Id field (while setting the Audience_Id field to 1, essentially 'deactivating' the record as Audience_Id is used as my Group_ID field).
I've got other things going on in the update, so I know its running; however this field is different from the others in that it uses a datasource column as the parameter source. Is there something I'm doing wrong here? (I rather not change the Audience_Id field into a hidden field, or even a session field, as that's too vulnerable to hackers.) When I change the custom update from a table type to a sql type, I see that the Audience_Id variable is, in fact, trying to look up a control, not a column. Is this a CCS glitch? Surly I can't be the first person to try to move information from one field to another.
Thanks in advance for any help or suggestions,
- Steve
|
 |
 |
SteveG
Posts: 56
|
| Posted: 02/25/2005, 4:46 PM |
|
Oh, one more thing, the datasource column is found in the forms datasource, but not for any controls, does this make a difference if it's not being used in the form?
|
|
|
|
SteveG
Posts: 56
|
| Posted: 02/25/2005, 5:44 PM |
|
Hey, just to beat anyone to my own punchline, after a whole afternoon of head-scratching, I just realized that I can use the session's GroupID in place of my own Audience_Id. So I've worked around the above issue; but if anyone has any advise in case I run up against it again, please let me know here.
Thanks,
- Steve
|
|
|
|
|
