Hello...

I want to avoid the error page when a record is already entered in the table. I`m going to be more specific...

I `ve got a table called "Table" and the primary key is contains two fields ("Unique_id" and "Name"). This mean that every user owns a Unique_id and is able to insert many records only if he types a different name each time! (I`m saying all these so that I can be more understoodable)
When ever a user tries to insert a "name" for a second time an error screen appears (The page cannot be displayed)...
So I would like a script so that on insert or on update it would check for a duplicate...

                              Thank you in advance!

set Rs1=server.CreateObject ("ADODB.Recordset")
sql="Select Name from Table where Name ='" &txtname& "'"
Rs1.Open sql,Conn ,1,3
if Rs1.RecordCount=1 then
msg="User Already exist"
end if


surendran
(Anything is Possible)

Hi there,

Probably you will have to check for Unique_Id too, as far as I understand this, it can have different names for single Unique_Id. If that is right, then your query should look something like this.
Else it will not let you add "xyz" as NAME again for another Unique_Id.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection