Robert Sorrells
|
| Posted: 06/28/2003, 5:16 PM |
|
I'm very familiar w. Macromedia MX for ASP development, but brand new to
CCS. I've created a login and a browse & form using CCS.
I want to be able to filter data in the grid / table, based on who's logged
in.
Whats a good strategy to do this in CCS?
In Macromedia MX, I would hand-code and UserID into a session variable. In
my table, I would integrate the session variable into my filter. The
latter could be done within the IDE.
Thanks!
Bob
|
|
|
 |
DonB
|
| Posted: 06/28/2003, 7:28 PM |
|
Same thing is done with CCS. Put the function ccGetUserID() into the
datasource WHERE list, specifying "Expression" as the Parameter Source.
This limits the rows to those with the appropriate ID.
Similarly, you can use ccGetGroupID() or ccUserInGroups() for broader
filtering based on security groups.
Actually, I've found it handy to put in the BeforeBuildSelect event many
times, and in there check what ccGetGroupID() returns. For the
"administrator" level(s), I can leave the recordset unfiltered, for others,
put the filter in.
http://www.gotodon.com/ccbth/Features/Knowledgebase.asp?find=filter
DonB
"Robert Sorrells" <rsorrellsU@KNOWmindspring.com> wrote in message
news:bdlb43$t3h$1@news.codecharge.com...
> I'm very familiar w. Macromedia MX for ASP development, but brand new to
> CCS. I've created a login and a browse & form using CCS.
>
> I want to be able to filter data in the grid / table, based on who's
logged
> in.
> Whats a good strategy to do this in CCS?
>
> In Macromedia MX, I would hand-code and UserID into a session variable.
In
> my table, I would integrate the session variable into my filter. The
> latter could be done within the IDE.
>
> Thanks!
> Bob
>
>
|
|
|
|
Robert Sorrells
|
| Posted: 06/29/2003, 4:32 AM |
|
Very nice. That worked beautifully. Thank you for the jump-start.
I'm running CCS's 20-day eval, and I will definitely buy it. Its exactly
what I need.
BTW, I've bookmarked you site.
Bob
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:bdlist$6hv$1@news.codecharge.com...
Same thing is done with CCS. Put the function ccGetUserID() into the
datasource WHERE list, specifying "Expression" as the Parameter Source.
This limits the rows to those with the appropriate ID.
Similarly, you can use ccGetGroupID() or ccUserInGroups() for broader
filtering based on security groups.
Actually, I've found it handy to put in the BeforeBuildSelect event many
times, and in there check what ccGetGroupID() returns. For the
"administrator" level(s), I can leave the recordset unfiltered, for others,
put the filter in.
http://www.gotodon.com/ccbth/Features/Knowledgebase.asp?find=filter
DonB
"Robert Sorrells" <rsorrellsU@KNOWmindspring.com> wrote in message
news:bdlb43$t3h$1@news.codecharge.com...
> I'm very familiar w. Macromedia MX for ASP development, but brand new to
> CCS. I've created a login and a browse & form using CCS.
>
> I want to be able to filter data in the grid / table, based on who's
logged
> in.
> Whats a good strategy to do this in CCS?
>
> In Macromedia MX, I would hand-code and UserID into a session variable.
In
> my table, I would integrate the session variable into my filter. The
> latter could be done within the IDE.
>
> Thanks!
> Bob
>
>
|
|
|
|
|
