Dian, In order to do it that way, you would have to maintain the recordset in memory in order to reuse it. Depending on the size of the recordset, that might not be a good idea. I would simply change your query to sort the records based on the users choice. Mark
Dian Chapman <[EMAIL PROTECTED]> wrote: Hi folks... I have a search for all records with a specific number. Now I would like to enhance the results (display) by allowing the author to not only see all the results of the search on their ID, but to display the results in various ways, such as highest to lowest rating...by article...by dates, etc. These are all additional fields in the DB. I'm just wondering what's the best way to do this and would appreciate any advice. I assume I could just run another search by holding the ID in a session var to allow me to continue new searches with that author ID and other records, depending on the new button they click...but I'm wondering if I can run a search on a RS? I mean, I already have the RS with all the author's articles displayed...can I do "something???" to resort this same RS in another way??? Or do I just query for another RS with different criteria? It SEEMS like resorting the current RS might be the most efficient way to do it...but I don't know how to do that...or IF its even possible. TIA for any advice. Cheers! Dian ~ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.681 / Virus Database: 443 - Release Date: 5/10/2004 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------- Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
