[FretBuzzz]

Hi, can somebody please explain the difference between the following two blocks of code:
(And when its a good idea to use one or the other)

Block A
========================================
dim myConnection, myRecordSet, myQuery
set myConnection = Server.createObject("adodb.connection")
myConnection.open "MY_DB"
set myRecordSet = server.createobject("adodb.recordset")
myQuery = "select * from myTable where myFieldB='x'"
dbtbl.open myQuery, myConnection , adOpenDynamic , adLockOptimistic
myRecordset("myFieldA") = "myNewvalue"
myRecordset.update
========================================

AND

Block B
========================================
dim myConnection, myRecordSet, myQuery
set myConnection = server.createobject("adodb.connection")
myConnection.open "MY_DB"
myQuery = "update myTable set myFieldA='myNewValue' where myFieldB='x'"
set myRecordSet = myConnection.execute(myQuery)
========================================

Thanks in advance,
FretBuzzz

[MMJ]

Different query so each does a different task.

[FretBuzzz]

From where I'm sitting, the results of these procedures are exactly the same... Which is better to use ?

[MMJ]

myQuery = "update myTable set myFieldA='myNewValue' where myFieldB='x'"
myQuery = "select * from myTable where myFieldB='x'"

2 different queries.

[FretBuzzz]

Thank you for that observation. Please note though that my question does not revolve around the queries, but the entire blocks of code. So I'll say again: Both these blocks of code do EXACTLY the same thing... My question is: Which block of code is better to use?

[MMJ]

And I'm saying that they don't both do the same thing.

Edit: Hmm... After closer observation it seems that they do seem to do the same thing although I could be wrong.

Basically they both update myFieldA to myNewValue however they do it using a different method.

However this might do some other config or changes: dbtbl.open myQuery, myConnection , adOpenDynamic , adLockOptimistic.

I would use the latter. What code is this? ASP/VBS?

[FretBuzzz]

As far as I can see, both blocks of code cause myFieldA in myTable to be changed to myNewValue, but only where an X is found in myFieldB

So what's the difference if both snippets produce the same results ?

[FretBuzzz]

Yes, it's VBS in ASP

[MMJ]

Originally Posted by FretBuzzz

As far as I can see, both blocks of code cause myFieldA in myTable to be changed to myNewValue, but only where an X is found in myFieldB

So what's the difference if both snippets produce the same results ?

Not too sure, never programmed in asp. One seems to be more specific.

[harmor]

Use Block B.

Edit:
What if you did this...

dim myConnection, myRecordSet, myQuery
set myConnection = server.createobject("adodb.connection")
myConnection.open "MY_DB"
set myRecordSet = myConnection.execute("update myTable set myFieldA='myNewValue' where myFieldB='x'")

[cristobal03]

Block B is faster and probably safer data-wise. To answer your original question, the difference is that the first example pulls a set of data into a recordset that is is created on the fly, then opens the recordset and changes the values of fields using what I assume is a built-in ASP function. The second example uses SQL native to the database itself to do the same thing in a single step.

HTH

chris.