Update a table if recordset exists????

[donniea21]

I have a multi page project which inserts data into tables in db....is there a way to make it so a page will search for existing recordset..if there is one....it will do an update if user changes info..if there isn't one than it will do an insert...i can see it as in if/else statement but can't figure out the syntax...thanks

 

[hblackorby]

ok, say I have a database with two fields name and password where all the names must be unique in a table called names. So...

set rs = Server.CreateObject("ADODB.Recordset&quot
set conn = Server.CreateObject("ADODB.Connection&quot
...open your connection to your database
name = request.form("name&quot
password = request.form("password&quot

SQL = "SELECT * FROM names where name='" & name & "'"
rs.open SQL, conn

'If it didn't find a name, INSERT, otherwise, UPDATE
if rs.eof then
rs.close
SQL = "INSERT INTO names (name,password) VALUES ('" & name & "','" & password & "')"
conn.Execute(SQL)
else
rs.close
SQL = "UPDATE names SET name='" & name & "', password='" & password & "' WHERE name='" & name & "'"
conn.Execute(SQL)
end if
set rs = nothing
conn.close
set conn = nothing

There you go!

Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO