Subject | join stored procedure and select |
---|---|
Author | intranetsbi |
Post date | 2005-07-25T12:20:57Z |
Hello!
I created stored procedure that returns 0/1 depending if a user has a
role or not. HasRole(UserID,Rolename):returns 0/1
Now I'd like to run a select from all users which have a certain role.
Why "select * from users, HasRole(users.id,'Admin')" is not working?
Thank you!
I created stored procedure that returns 0/1 depending if a user has a
role or not. HasRole(UserID,Rolename):returns 0/1
Now I'd like to run a select from all users which have a certain role.
Why "select * from users, HasRole(users.id,'Admin')" is not working?
Thank you!