UPDATE Command for sql ... lots of detail about the problem

Originally posted by : Andy (origin42@mailcity.com)Dim sDBConnectDim sSQLQueryDim pDBDim pRSsDBConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("poll.mdb") sSQLQuery = "SELECT * FROM polls WHERE id=1"Set pDB = server.createobject("ADODB.Connection") : pDB.Open sDBConnect Set pRS = Server.CreateObject("ADODB.Recordset") : pRS.Open sSQLQuery,pDB,3My friend is a web designer for a local company and this is how he showed me to connect to a DB in access and how to access data in the DB. Recently I have been learning alot more about ASp using the WROX book beginning ASP 3.0, this book is very godd and i have learnt. it uses the same ideas for the above but in diffrent words and with subtle diffrences and so i cant see in my head how the two work the same, as a result i cannot figure out how to use the UPDATE command.

Originally posted by : NatepDB.execute ("UPDATE TableName SET ColumnName=Value,ColumName2=Value2 WHERE uniqueID = "Also, look into command object.------------Andy at 9/9/2001 11:23:05 AMDim sDBConnectDim sSQLQueryDim pDBDim pRSsDBConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("poll.mdb") sSQLQuery = "SELECT * FROM polls WHERE id=1"Set pDB = server.createobject("ADODB.Connection") : pDB.Open sDBConnect Set pRS = Server.CreateObject("ADODB.Recordset") : pRS.Open sSQLQuery,pDB,3My friend is a web designer for a local company and this is how he showed me to connect to a DB in access and how to access data in the DB. Recently I have been learning alot more about ASp using the WROX book beginning ASP 3.0, this book is very godd and i have learnt. it uses the same ideas for the above but in diffrent words and with subtle diffrences and so i cant see in my head how the two work the same, as a result i cannot figure out how to use the UPDATE command.

Originally posted by : AndyThanks m8 ------------Nate at 9/10/2001 12:17:43 PMpDB.execute ("UPDATE TableName SET ColumnName=Value,ColumName2=Value2 WHERE uniqueID = "Also, look into command object.------------Andy at 9/9/2001 11:23:05 AMDim sDBConnectDim sSQLQueryDim pDBDim pRSsDBConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("poll.mdb") sSQLQuery = "SELECT * FROM polls WHERE id=1"Set pDB = server.createobject("ADODB.Connection") : pDB.Open sDBConnect Set pRS = Server.CreateObject("ADODB.Recordset") : pRS.Open sSQLQuery,pDB,3My friend is a web designer for a local company and this is how he showed me to connect to a DB in access and how to access data in the DB. Recently I have been learning alot more about ASp using the WROX book beginning ASP 3.0, this book is very godd and i have learnt. it uses the same ideas for the above but in diffrent words and with subtle diffrences and so i cant see in my head how the two work the same, as a result i cannot figure out how to use the UPDATE command.