dim journal_key_words
                            str="dsn=sql;uid=sa;pwd=sa;" dim c,r
                                    set c=server.CreateObject("adodb.connection")
                                set r=server.CreateObject("adodb.recordset")

                    c.open str

            r.open "journal_key_words",c,2,2

            r.addnew

            r(0).value=request("accno")
            r(1).value=request("keywords")
r.update
r.close
------------------------------How I come to know that whether this record already exits, Plesae help me
Bye

Zaeem Sherazi

__________________
Zaeem Sherazi

dim journal_key_words
str="dsn=sql;uid=sa;pwd=sa;"
dim c,r
set c=server.CreateObject("adodb.connection")
set r=server.CreateObject("adodb.recordset")
set r1=server.CreateObject("adodb.recordset")
c.open str
accno=Request("accno")
sql1="select * from tablename where fielname='"&accno&"'"
         r1.Open sql1,c,1,3
if r1.BOF then
sql="select * from tablename"
r.open sql c,1,3
r.addnew
            r(0).value=request("accno")
            r(1).value=request("keywords")
r.update
r.close
else
Response.Write "already exits"
end if

surendran