Jonathon Surratt
|
| Posted: 02/16/2003, 4:20 PM |
|
Hi, I have been working with CodeCharge Studio for days straight trying to
figure out one thing!! I have searched tons of documentation and lists, but
haven't had any luck. This is what I am doing:
I have created an application using the application builder. I am using
ASP.
I have a login page. After logging the user in they come to a page called
"tblusers_list" This page contains a grid that lists all of my "members"
complete with their information....works fine. I even have a link that says
"update" and it takes them to a page called "tblusers_maint....where
information can be updated in the database. It works fine. Here is where
the problem is:
When a user logs in and and goes the the "tblusers_list" page, I only want
them to see their information in the grid..not everyone elses! I have been
trying to figure this out for hours upon hours...but no luck!!
Everyone has their own "user_id" which is the primary key for the table.
Is there anyway that upon entering the "tblusers_list" that I can write a
statement or something that takes their login information (username and
password) and looks at the database to get their "user_id" and only
generates their information in the "tblusers_list" grid??? Please any
detailed information will be GREATLY appreciated!!
Thanks in advance!
|
|
|
 |
Robert Rodgers
|
| Posted: 02/16/2003, 5:08 PM |
|
Jonathon,
Click on the grid so you can see the properties. Select the datasource
property. Goto the property page by clicking on the button with the three
dots.
If your datasource type is Table you can just add a filter to the where
clause by pressing the Plus button.
Select your field from the table you want to limit by on the left under the
Field label.
Then you can either
Type "CCGetUserID()" In the field under Parameter Field label.Change the
Type to Expression.
Or
Type "UserID" in the field under the Parameter Field label. Change the type
to Session.
There are probably other ways but both of these should work.
rob
"Jonathon Surratt" <jsurratt@adelphia.net> wrote in message
news:b2p9sr$7ka$1@news.codecharge.com...
> Hi, I have been working with CodeCharge Studio for days straight trying
to
> figure out one thing!! I have searched tons of documentation and lists,
but
> haven't had any luck. This is what I am doing:
>
> I have created an application using the application builder. I am using
> ASP.
>
> I have a login page. After logging the user in they come to a page called
> "tblusers_list" This page contains a grid that lists all of my "members"
> complete with their information....works fine. I even have a link that
says
> "update" and it takes them to a page called "tblusers_maint....where
> information can be updated in the database. It works fine. Here is where
> the problem is:
>
> When a user logs in and and goes the the "tblusers_list" page, I only want
> them to see their information in the grid..not everyone elses! I have
been
> trying to figure this out for hours upon hours...but no luck!!
>
> Everyone has their own "user_id" which is the primary key for the table.
> Is there anyway that upon entering the "tblusers_list" that I can write a
> statement or something that takes their login information (username and
> password) and looks at the database to get their "user_id" and only
> generates their information in the "tblusers_list" grid??? Please any
> detailed information will be GREATLY appreciated!!
>
> Thanks in advance!
>
>
|
|
|
|
|
