Member Avatar for MunMun

i have create a database and a form. i need to check the input data before store it into the database. so that, there are no overlap data in my database. its in Asp langauge. thanks for your help.

  • 3 Contributors
  • 2 Replies
  • 158 Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by dassmobin
Member Avatar for DVHost

In the future you may want to be just a little bit more specific about your project such as the type of DB etc. But, here is a very easy method of checking records in an Access DB to see if they already exist:

<%
Dim rsGET
Set rsGET = Server.CreateObject("ADODB.Recordset")
rsGET.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myDatabase.mdb"
rsGET.Source = "Select myRecord from myTable where myRecord = " + formValue
rsGET.CursorType = 0
rsGET.CursorLocation = 2
rsGET.LockType = 1
rsGET.Open()
 
If rsGET.BOF OR rsGET.EOF Then 
 
' NO MATCHING RECORDS FOUND CODE
 
Else
 
' FOUND MATCHING RECORDS CODE
 
End If
%> 
 
' Other html code here
 
<%
' Destroy and close the db connection
 
rsGET.Close()
Set rsGET = Nothing
%>

rsGET.BOF and rsGET.EOF stand for Beginning of File and End of File respectively.

To the server, if it reaches either end of the DB and has not found anything then it will fire the 'NO MATCHING RECORDS code. If it does find the record in question it will fire the FOUND MATCHING RECORD code after the Else statement.

Hope it helps!

Member Avatar for dassmobin

I took a look at your site and recommend it to my visitors. I agree with you on the importance of becoming valuable in many different areas. I believe that it sustains any entrepreneur during challenges that inevitably occur.
------------------
Mobin

<URL SNIPPED>

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.