Put the recordset into a temp table then search the temp table. The code is
a little complex but that is the logic.
Brian
-----Original Message-----
From: CT, Loo [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 3:58 PM
To: Cf-Talk
Subject: Reuse a recordset.
Dear all gurus,
Please help!!!
I have a scenerio here:
I am developing a page to provide user for searching capability.
Initially,
user will enter a broader search criteria and in the coding I name
the query
as "getresult" and it return a recordset of 500 records out from the
database. The result is displayed to user. Now, I would like to
allow the
user to narrow down the search with more detail criteria. How can I
prevent
the system to repeat the search through the whole database again?
Instead I
would like to search WITHIN these 500 records found earlier. Is
there anyway
to reuse the recordset? Please advise.
Thank you.
Kind regards,
loo
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
