Querying a recordset

Results 1 to 2 of 2

Thread: Querying a recordset

  1. #1
    Join Date
    Dec 1969

    Default Querying a recordset

    I have a certain recordset rs in which I keep on appending records. At the completion of building this recordset, I have many duplicate values in it. I want to build another recordset object which should query the earlier one which I have created. <BR><BR>Something like :<BR><BR>&#060;%Set rs1 = conn.execute("Select distinct id from " & rs)%&#062;<BR><BR>where rs is not a physical table but a virtual recordset.<BR><BR>Is there any possible way to run this kind of query? Or any alternative to acheive such results.<BR><BR>Regards<BR>Santosh

  2. #2
    Join Date
    Dec 1969

    Default RE: Querying a recordset

    I believe (check the docs on this) that there is a clone() method of the recordset object which you can then filter in various ways.<BR><BR>sounds very convoluted though, as it is - is this necessary? can you go a simpler way?

Posting Permissions

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