Logo

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
Tags: asp, databases
Tag cloud
diy photography databases html utilities dotnet vbscript denmark asp javascript aspnet ajax copenhagen japan modding

Search

Feeds
RSS 2.0 feed All content
RSS 2.0 feed ajax
RSS 2.0 feed asp
RSS 2.0 feed aspnet
RSS 2.0 feed copenhagen
RSS 2.0 feed databases
RSS 2.0 feed denmark
RSS 2.0 feed diy
RSS 2.0 feed dotnet
RSS 2.0 feed html
RSS 2.0 feed japan
RSS 2.0 feed javascript
RSS 2.0 feed modding
RSS 2.0 feed photography
RSS 2.0 feed utilities
RSS 2.0 feed vbscript