--------------- rudy wrote: --------------- : actually both your query and your sample page show them in : ascending order
Sorry, typo. Ascending is what it is and what I was after. What I'm curious about here is what the best method of letting the user specify a starting date to browse events at and give them the ability to browse backward through time as well as forward from that date? Currently my select statement prevents this... here it is again, for reference: SELECT * FROM myTable WHERE evtDate > userDate ORDER by evtDate The scenario I'm envisioning is that a user might have a general idea what time range the specific event they are looking for falls in, but not precisely when. So, lets say they think the event is at the beginning of February, but it is actually at the end of January... I'd like to provide some simple forward - backward navigation to make it easier to find a particular event. Currently, the way my select statement works, there is no such thing as going back in time if you are at the beginning of the recordset. See the problem? So... what's a good way to implement this? My thoughts are: - have a separate select statement that does some wizardry to figure out the most recent n events before the specified start date Caveat: Just seems complicated and unwieldy. - Select *everything* from the database, figure out what page the selected start date falls on and set absolutePage to the derived value, which will allow paging back and forth through time freely. Caveat: Could get *very* slow as data grows. I can work out the how, I'm just looking for best practice or perhaps a better idea altogether. Thanks, Stephen Caudill http://www.mechavox.com/ ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
