--------------- rudy wrote: --------------- <snip /> : so go to the database, grab a recordset based on something, and : while you're printing it out for the user, remember the primary : key of the first one you printed and the last one you printed
*** This is where the Aha! occured at :) <snip /> : if down : : select * from : ( SELECT top 10 * FROM myTable : WHERE evtDate < 20031225 : ORDER by evtDate desc ) : order by evtDate asc : : if up : : SELECT top 10 * FROM myTable : WHERE evtDate > 20040114 : ORDER by evtDate asc : : : helps? Helps? Yes, Helps! You. Da. Man. Thanks for curing me of my case of "Can't see the forest for the tree-itis". When I shared this with two of my coworkers who had pondered this with me, you earned a collective "d'oh!" from the lot of us. Thanks Very, Very Much! Stephen 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.
