Checking if User Exists

Results 1 to 3 of 3

Thread: Checking if User Exists

  1. #1
    Join Date
    Dec 1969

    Default Checking if User Exists

    Before Adding some new record to a db, I want to check if the usercode, already exists in the db.. How Can I Do This???<BR><BR>This Is What I Have so far<BR><BR>---------------------------------------------------------------<BR><BR> strSQL = "INSERT INTO tTipo_curso(Codigo, Descripcion)" &_<BR> "VALUES(&#039;" & (p_codigo) & "&#039;, &#039;" & <BR> (p_descripcion) & "&#039;)"<BR><BR> &#039;Response.Write strSQL<BR> &#039;Response.End<BR> Session("adoConexion").Execute strSQL<BR> Response.Redirect "inicio.asp"

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs

    Under database categories... "How can I tell if a record exists?"

  3. #3
    Join Date
    Dec 1969

    Default RE: Checking if User Exists

    you have to check use sql select * from.. where name=newname<BR>check if they have it return yes<BR>Name already in DB<BR>if not return no<BR><BR>strSQL = "INSERT INTO tTipo_curso(Codigo, Descripcion)" &_<BR>"VALUES(&#039;" & (p_codigo) & "&#039;, &#039;" & <BR>(p_descripcion) & "&#039;)"<BR><BR>&#039;Response.Write strSQL<BR>&#039;Response.End<BR>Session("adoConexi on").Execute strSQL<BR>Response.Redirect "inicio.asp"<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