Update a record in a database with classic ASP
A basic example showing how to execute an SQL statement which does not return a record set.
Dim strDbConnection
Dim objConn
Dim strSQL
strDbConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test.mdb;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(strDbConnection)
strSQL = "UPDATE persons SET fullName = 'John Doe' WHERE uID = 10"
objConn.Execute(strSQL)
objConn.Close()
Set objConn = Nothing
Dim objConn
Dim strSQL
strDbConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test.mdb;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(strDbConnection)
strSQL = "UPDATE persons SET fullName = 'John Doe' WHERE uID = 10"
objConn.Execute(strSQL)
objConn.Close()
Set objConn = Nothing