View Single Post
  #2 (permalink)  
Old March 3rd, 2006, 08:27 PM
adam_kahtava adam_kahtava is offline
Wrox Technical Editor
 
Join Date: Dec 2005
Location: , , Canada.
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How to find out if a record already exists in a database, If it doesn't Insert A New Record: http://www.dmxzone.com/ShowDetail.asp?NewsId=4615

Here's a quick example from the link above:

<%
  Dim strSQL
  strSQL = "SELECT * FROM MyTable WHERE username = '" & _
            Request.Form("username") & "'"
  Set rs = db.Execute()

  If rs.EOF Then
    'Record does not exist
  Else
    Response.Write "Record exists"
  End If
%>

- A.Kahtava
Reply With Quote