Why update statement doesn't work

[chrisdq]

Hi,

I can't figure out why the update query to access database doesn't work from ASP while it works fine with the select statement.
Here is what is have for the update statement

Public function testUpdate
dim conn, rs, x, correctpass, username, sqlquery, SQL

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/Inetpub/

http://wwwroot/ODBC.mdb"

set rs = Server.CreateObject("ADODB.recordset")

SQL = "UPDATE records " & _
"SET records.userid = '33dell' " & _
"WHERE records.username = 'dell'"
rs.Open SQL, conn

rs.close
conn.close
end function

I keep getting the error "No value given for one or more required parameters.
session-class.asp, line 85 which points to
rs.Open SQL, conn.
Can anyone see why it doesn't work?
Thank for anyone can help.

 

[Tarwn]

Generally when you get that error from Access it's because you have mispelled a field name in your SQL statement. try pasting that statement directly into Access and see if it pops up an input to get a value for one of the field names. If it does then that field is either mispelled or hasn't been added to your table yet.

 

[JoeAtWork]

Recordset objects aren't meant for doing UPDATE statements, they're meant for retrieving data. Use an ADODB.Command object instead.

 

[chrisdq]

I got it to work.
I was supposed to use rs.execute (sql) instead of rs.Open SQL, conn.

Thanks everyone.