Thanks for all the info! The results can quickly build with this...but I also have another page that I've been thinking about doing this way. So thanks much for the info...this isn't urgent, so I'm going to think about it and mess with it next week. And yes, both are for web apps.
Appreciate the help! Dian ~ -----Original Message----- From: Mat�as Ni�o [mailto:[EMAIL PROTECTED] On Behalf Of Mat�as Ni�o ListMail Sent: Sunday, May 16, 2004 1:36 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Can I resort an RS? Dian, I'm assuming this is with a web application. The "best way" to do it mainly depends on the amount of results. If the RS is a quick query, you can just reload the page and build the RS given the user's choice of "view by". The way I usually do it is just build a link button with the querystring values of "id=x&viewby=[date/article/rating]". [NOTE: I usually try to keep the selected id in the querystring, as opposed to a Session variable, but either way works.] So when the page reloads and you build the SQL for the RS, you can determine the 'order by' based on the state of request.querystring("viewby"). For a quick'n'dirty example, If request.querystring("viewby") = "date" then SQL = "Select * from Table WHERE ID = " & [request.querystring("id") or Session("ID")] & " ORDER BY DateField" Else SQL = [default SQL] End if If you go this route, you'll probably want to use a select case to handle all the different possible SQL statements. Alternatly, if you have (or will eventually have) a ton of records with more than 250 users and you can't afford to keep reloading the page everytime a user needs to reorder his results, you can always use javascript to reorder the result items on the client browser without having to reload the page. If so, I think there's plenty of free javascript code out there dealing with item sorting. Hope this helps and Good luck! -Mat�as > -----Original Message----- > From: Dian Chapman [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 15, 2004 8:25 PM > To: Group - ASP > Subject: [ASP] Can I resort an RS? > > 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 > > > > > > > --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.686 / Virus Database: 447 - Release Date: 5/14/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.686 / Virus Database: 447 - Release Date: 5/14/2004 ------------------------ Yahoo! Groups Sponsor ---------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- 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/
