Assigning values to recordSet fields

How do you assign values to fields in a recordset?

What I'm doing:

SELECT fname, lname, dummy, workorder, description _
FROM Workload

Field dummy is a field containing a value of 0.


My objective is:

In my ASP I want to do a test with the current user. If the test is true, I want to assign the value of 1 to dummy for that record. Then later in the ASP I want to resort the recordset using dummy in desending order to display the current user's info before all other records.

I've tried such things as rs.Update dummy,1. I never got this to work. I don't know enough to know if this is even a valid use of this method, but it didn't show an error. There may be an easy way to accomplish this, but if there is, its escaped me.

Thanks in advance for any help.

Theo

Can you translate that into English (no code, just an explanation)? As I often used to state (and still do at times) in the javascript forum, "What are you trying to accomplish?"

No offense intended, but I'm not clear on what you're trying to do after reading your explanation...

If you want to assign a value to a field in a recordset, then you just update that value depending upon whatever logic you implement.