title: How does, "select for update" work using vbscript?
body: <p>I'm trying to write a simple script that will query the database and retrieve a piece of information from the database.  I'll then do something with that information and then update it's record with some sort of a result.  I'll have 10 threads running doing the same thing.  I want to make sure that another thread doesn't select an already selected row.  </p>
  
  <p>My question is how do I do this in vbscript?  I can run queries and updates no problem but is there something special I have to do to lock the row, do some work, update the record and commit? </p>
  
  <p>How would I accomplish this?</p>