Wee Ler Ping
|
| Posted: 03/15/2002, 11:16 PM |
|
Dear CodeCharge,
How do I implement the following?
I would like to use JSP to list the values of a listbox. Say, a User logs
in, UserID is 1. So the session variable should be UserID with value 1.
Each User can be a leader of multiple Groups, but not all the Groups. How do
I use SQL to tell the listbox to display Groups that this User (1) is the
leader of, but not display ALL the groups (i.e. do not display groups that
he is not the leader of)
Any help will be appreciated!
|
|
|
 |
Wee Ler Ping
|
| Posted: 03/15/2002, 11:21 PM |
|
I know the SQL should be something like this ...in the Lookup portion of the
Grp listbox...
SELECT * from GROUPS where GroupLeader = " + leadername + "
___
leadername is this --> String leadername =
(String)session.getAttribute("UserID"); and it also used in other instances
so it does manage to store value successfully, but when displaying out
groups the listbox appears empty! Why is this so?
Yours,
Ler PIng
|
|
|
|
Wee Ler Ping
|
| Posted: 03/16/2002, 12:39 AM |
|
Oh! i managed to solve it by adding a coupla Dashes in the SQL
statement...but Have one other question.
How do I turn the standard INSERT link in any GRID into an actual Button?
Any ideas?
|
|
|
|
|
