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


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