Slim Pickens
|
| Posted: 10/23/2002, 9:06 AM |
|
New to CCS, set the project as ASP.net using VB.
Trying to filter the recordset based on the "CompanyKey" field located in
both my "Users" table and my "Employees" table where UserID = CompanyKey.
I have the login where I defined the the UserId as "CompanyKey" from my
Users Table under Security so I am assuming that the "CompanyKey" field is
being passed as a session.userid variable.
How do I filter the data on my employeeslist page to list only those records
associated with the CompanyKey of the UserID logged in?
I tried to query the "employees" table on this page by using the query
builder and added CompanyKey as the field name, session.userID under the
parameter source and session as the type. But I get zero records.
Or am I completely off base and should use the "Before Show" event to filter
the records. If so how.
Thanks in advance.
Steve
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 10/24/2002, 2:39 AM |
|
Make sure that parameter source type is Code Expression if you enter
CCGetUserID there.
--
Alex,
Support Engineer
CodeCharge Team
"Slim Pickens" <slimp@aol.com> wrote in message
news:ap6hdr$14s$1@news.codecharge.com...
> New to CCS, set the project as ASP.net using VB.
>
> Trying to filter the recordset based on the "CompanyKey" field located in
> both my "Users" table and my "Employees" table where UserID = CompanyKey.
>
> I have the login where I defined the the UserId as "CompanyKey" from my
> Users Table under Security so I am assuming that the "CompanyKey" field is
> being passed as a session.userid variable.
>
> How do I filter the data on my employeeslist page to list only those
records
> associated with the CompanyKey of the UserID logged in?
>
> I tried to query the "employees" table on this page by using the query
> builder and added CompanyKey as the field name, session.userID under the
> parameter source and session as the type. But I get zero records.
>
> Or am I completely off base and should use the "Before Show" event to
filter
> the records. If so how.
>
> Thanks in advance.
>
> Steve
>
>
>
>
|
|
|
|
Slim Pickens
|
| Posted: 10/24/2002, 6:37 AM |
|
Alexey:
Thanks for the reply.
I do not have the type Code Expression under the combo box, only
Application, Form, URL, Session, Expression, or cookie.
Tried them all, still no luck?
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ap8f3g$hid$2@news.codecharge.com...
> Make sure that parameter source type is Code Expression if you enter
> CCGetUserID there.
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
> "Slim Pickens" <slimp@aol.com> wrote in message
>news:ap6hdr$14s$1@news.codecharge.com...
> > New to CCS, set the project as ASP.net using VB.
> >
> > Trying to filter the recordset based on the "CompanyKey" field located
in
> > both my "Users" table and my "Employees" table where UserID =
CompanyKey.
> >
> > I have the login where I defined the the UserId as "CompanyKey" from my
> > Users Table under Security so I am assuming that the "CompanyKey" field
is
> > being passed as a session.userid variable.
> >
> > How do I filter the data on my employeeslist page to list only those
> records
> > associated with the CompanyKey of the UserID logged in?
> >
> > I tried to query the "employees" table on this page by using the query
> > builder and added CompanyKey as the field name, session.userID under the
> > parameter source and session as the type. But I get zero records.
> >
> > Or am I completely off base and should use the "Before Show" event to
> filter
> > the records. If so how.
> >
> > Thanks in advance.
> >
> > Steve
> >
> >
> >
> >
>
>
|
|
|
|
|
