Forum Replies Created

Viewing 13 posts - 31 through 43 (of 43 total)

  • RE: tsql

    Thank you Mark. After doing a bit more research I have come to the same conclusion. I am new to this, so it will be a challenge to get this...

  • RE: datalist/repeater

    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,

    ...

  • RE: datalist/repeater

    Thank you, this sounds like a great solution.

  • RE: cookies/ session

    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...

  • RE: General SQL question

    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...

  • RE: General SQL question

    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...

  • RE: General SQL question

    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

  • RE: General SQL question

    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.

  • RE: General SQL question

    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....

  • RE: General SQL question

    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...

  • RE: General SQL question

    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...

  • RE: General SQL question

    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...

  • RE: General SQL question

    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...

Viewing 13 posts - 31 through 43 (of 43 total)