Home | Advertising Info53 USERS CURRENTLY ONLINE   
   Site Search Contact Us Friday, October 28, 2016  


Try a free httpZip trial now and compress for less!

We didn't realize
the site was so popular.

Other Stuff

Using ADO to update an existing record.

In this example we are using ADO to update an existing record. The SQL statement is the key and by changing that you can update whatever record you want to.

This is just an example to get you started.

<% ID = 7 %>
<% NAME = "Joe Smoe" %>
<% MESSAGE = "This is another test" %>

' declaring variables
' not neccesary but a good habit
Dim DataConn
Dim CmdUpdateRecord
Set DataConn = Server.CreateObject("ADODB.Connection")
Set CmdUpdateRecord = Server.CreateObject("ADODB.Recordset")
' The line below shows how to use a system DSN instead of a DNS-LESS connection
' DataConn.Open "DSN=System_DSN_Name"
DataConn.Open "DBQ=" & Server.Mappath("../_database/database.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
MYSQL = "SELECT some_table.* FROM some_table WHERE (ID = " & ID & ")"
CmdUpdateRecord.Open MYSQL, DataConn, 1, 3
CmdUpdateRecord.Fields("NAME") = NAME
CmdUpdateRecord.Fields("MESSAGE") = MESSAGE
' closing objects and setting them to nothing
' not neccesary but a good habit
Set CmdUpdateRecord = Nothing
Set DataConn = Nothing


   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright 1998 - 2016 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com