Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jun 2002
    Location
    Atlanta
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Last edited by whammy; 02-15-2003 at 01:17 AM.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •