Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Barcelona
    Posts
    22

    Unanswered: Check mail and password with sp

    How can I write a stored procedure with SQL 2000 Server to check an e-mail and password entered by the user, and if both exist select the Id field ?

    Table ‘Users’:
    UserId
    First_name
    Surname
    Age
    E-mail
    Password

    If it is possible I would like to know how can I write the error messages in three cases: If ‘E-mail’ doesn't exist, if ‘password’ doesn’t exist and if both doesn’t exist. And I would like that those messages would be able to appear on the website application.


    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check Planet SC for any CE.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Location
    Barcelona
    Posts
    22
    Ok thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •