Re: Simulating ASP/ADO commands in PHP

> I'm not up on ANSI92 standards - I'm not sure if LIMIT is in there, but it's > there in MySQL and I believe Postgres and Oracle (someone correct me if > I'm wrong). Having the database do this work is, imo, a much better > way of doing it. Of course, if you're using MSSQL server, you can't do it, > but many other databases will let you do this. (BTW, if anyone claims that > MS doesn't support LIMIT because it's not an officially approved standard, > what about MARQUEE?) ;) No, LIMIT is not an ANSI92 standard. I actually added LIMIT to mSQL-1.x back in 1995. I didn't even read the ANSI92 standard and just picked a word that seemed to describe what the clause did. MySQL then picked it up and improved on the concept by allowing a range instead of just a hard limit on the number of returned rows which is what I had done in mSQL. So, I can say with a whole lot of authority that LIMIT is not in any standard anywhere. -Rasmus