Believe me, it's not my first choice .... I hate working with M$ as much as the next guy. Unfortunately, not every project leans in the direction I want it to. As far as the LIMIT function goes I think MySQL has spoiled me. The only easy way to do pagination in ASP is through the ADO Object. The problem is that I won half the battle by getting to use PHP, but I lost the MySQL battle so I'm left with this dilemma. I think using the TOP declaration that I'll be able to come up with some workarounds in Stored Procedures. Sorry for mentioning M$ here, but it seemed like a question that has most likely terrorized at least a few other people on the list so I figured it was worth a try. --Toby ----- Original Message ----- From: "B. van Ouwerkerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 11:31 AM Subject: Re: LIMIT > > >seems redundant and I really hate the fact that LIMIT is not supported. > >Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 > >are both appreciated. > > M$??.. thought this was about MySQL :-) > > I wouldn't know.. I do know you can find a few newsgroups somewhere at > news.microsoft.com this question will fit nicely there.. > > Bye, > > > B. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
