Ugh - After I started looking at this I realized that it's an Access DB - not SQL Server (which I'm used to working with). I'm guessing that might be the difference?
Todd -----Original Message----- From: r937 [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2008 5:02 PM To: wdvltalk@lists.wdvl.com Subject: Re: [wdvltalk] Limited Records - ASP > Here is the original - "SELECT * FROM events ORDER BY StartDate" > > Without anything, I will get 10 events listed on the page. If I try > "SELECT TOP 5 * FROM events ORDER BY StartDate", > then I only get the first 2 events. quite frankly, i just do not believe that try running it in Query Analyzer or whatever your front-end-tool-du-jour many times, what people think is an SQL problem turns out to be a problem in their app logic dealing with a perfectly good SQL result set ;o) besides, you want SELECT TOP 5 ... ORDER BY StartDate DESC because you want the latest 5 ____ . The WDVL Discussion List from WDVL.COM . ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ 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. ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ 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.