Query a record set

Results 1 to 3 of 3

Thread: Query a record set

  1. #1
    Join Date
    Dec 1969

    Default Query a record set

    I have a record set and I want to perform a quick check to see if a value exists. Is there a way to query the record set without just cycling through each row looking for the value?

  2. #2
    Join Date
    Dec 1969

    Default RE: Query a record set

    Take a look at the Find method in the ADO docs. <BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthfindmethodado.asp

  3. #3
    Join Date
    Dec 1969

    Default Why not just use SQL...

    ...to only get the records you are interested in, in the first place???<BR><BR>Yeah, you *can* use FIND as Xander says, but your performance may be really really horrible, depending on how many records you are working with.<BR><BR>RULE 1: Use SQL to *start* by getting *only* the records you will process in the ASP page. *THEN*, if there&#039;s something you need to do beyond that, rule 2 applies.<BR><BR>RULE 2: Thing about your problem again. Are you sure you can&#039;t find a SQL solution to it?<BR><BR>

Posting Permissions

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