Data Validation

Results 1 to 2 of 2

Thread: Data Validation

  1. #1
    David Highlander Guest

    Default Data Validation

    I am passing two fields into my database called : "username" and "password"<BR><BR>How can I make sure that these username and passwords are not duplicated in the database by another user?<BR><BR>For reference - these two fields are part of a much larger db such as name, address, etc.

  2. #2
    Join Date
    Dec 1969

    Default RE: Data Validation

    Open a connection to the recordsets in the database and then query up the records.<BR><BR>You can do an if then stmt making sure there are no duplicates.<BR><BR>If rs("name") = request("name") and rs("pwd") = request("pwd") then<BR> &#039don&#039t put in database or whatever<BR>end if<BR>

Posting Permissions

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