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")
strSQL = "UPDATE persons SET fullName = 'John Doe' WHERE uID = 10"
Set objConn = Nothing
Tags: asp, databases
Tag cloud
photography utilities ajax asp diy dotnet databases html japan javascript vbscript denmark aspnet copenhagen modding


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