Juergen Oschadleus
|
Posted: 02/23/2004, 7:02 PM |
|
I've been using CodeCharge Studio for several weeks and think it's a
fabulous tool for people new to programming and developing. I have a
question on creating a stored procedure, and hope someone can provide some
direction.
When new users register on the system their details are stored in
tblUsername, along with a default Group = User. A system administrator can
change the Group value to "Presenter" or "Admin". User details are stored in
a separate table, tblUserDetail, which includes a checkbox for "Presenter".
What I'd like is a stored procedure which checks the tblUserDetail.presenter
field. If checked, and the tblUsername.group value is set to User, the group
value should be changed to Presenter. Any other value (Presenter/Admin)
should not change.
I'm using an MS Access 2000 database with ASP 3.0. Any assistance would be
appreciated.
Juergen
|
|
|
svthomson
Posts: 1
|
Posted: 10/05/2004, 10:09 PM |
|
I know it's late but searchers might find this useful.
If you don't know how to create a stored procedure then just look that up. It's very easy. Then under events for the login page you would call the sproc just like you would a select statement, except precede it with 'exec'.
E.g.
Set objConn = New clsDBConnection
objConn.Open
Set objRs = objConn.Execute("exec dbo.GetUserDetails")
' do with it what you will
hth,
steve
_________________
___________
-st
There are 10 types of people in this world - those who understand binary and those who don't...
|
|
|
|