Viewing 13 posts - 31 through 43 (of 43 total)
I have been working on all morning and I am stuck.
This is my stored procedure
(
@ClientID INT
)
AS
SELECT dbo.User_Information.User_ID, dbo.User_Information.First_Name, dbo.User_Information.Last_Name, dbo.User_Information.Email_1,
...
March 31, 2005 at 12:39 pm
Sorry for the delay have been working on my navigation system.
I have my login all set based on a user_name which works great. It passes the user_name and the user's...
March 10, 2005 at 1:07 pm
I figured that was the case with the Scope_Identity()
All of my tables are linked with the UserID which is the Identity field in the User table.
So I would just...
March 9, 2005 at 4:56 pm
Hey Phil,
I have another form that follows the first one you helped me with. I wanted to make sure I am on the right track with my stored procedure.
ALTER...
March 9, 2005 at 10:51 am
Will test it tomorrow. I am not able to access the SQL server from the IP.
Thank you for all of your help Phill
-Curtis
February 23, 2005 at 7:10 pm
I am using Visual Studio.net and the web host has a sql manager page where the usersroles table was created. The users table already existed.
February 23, 2005 at 6:47 pm
Yes, UsersRoles is the right name for the table. I don't know if this makes a difference but the Users table is listed as Users(dbo) and UsersRoles is just UsersRoles....
February 23, 2005 at 6:15 pm
Phill, thank you!
It now ads the new user to the users table but it also gives me this error message:
Server Error in '/Global' Application.
--------------------------------------------------------------------------------
Invalid object name 'UsersRoles'.
Description: An unhandled...
February 23, 2005 at 4:52 pm
No the UserID is the IDENTITY column.
I don't have a stored procedure set up for UserRoles
This is my stored procedure that I call when the user hits "Register"
ALTER PROCEDURE...
February 23, 2005 at 4:16 pm
Ok, I DECLARED @NewID as an INT.
I made your suggested changes to the stored procedure except I removed the RoleID because it has a default value associated to it.
The...
February 23, 2005 at 8:22 am
I use a stored procedure.
How will I pull the userId from the main table to insert into to the UsersRoles table
this is my stored procedure
ALTER PROCEDURE dbo.DBRegister
(
@FirstName Varchar( 100 ),
@LastName...
February 22, 2005 at 4:41 pm
Viewing 13 posts - 31 through 43 (of 43 total)