2 Replies Latest reply on Oct 8, 2006 7:10 PM by samagination79

    Query/Filter a recordset object

    samagination79
      In an app i'm working on I'm returning a full recordset when the app initializes and I'd like to be able to find specific records from that.

      eg. I have a query that returns a recordset with userid, firstname, lastname;

      --------------------
      1 | sam | smith
      2 | john | smith
      --------------------

      and lets say i'm storing that in a variable called userRS

      how do I then return a single record from userRS by passing through a userid?