Re: Oracle row limit support (again)

Hello, "Tomas V.V.Cox" wrote: > > Well, finally I thought in a better solution for the problem. Instead of > breaking my head with the SQL parser and trying to guess the resultant > columns for building the special query needed by the limit stuff, I used > a nice trick: launch the real query but with a special clausule (WHERE > NULL = NULL) that won't return anything execept the field names I need. Shouldn't that be NULL<>NULL? NULL=NULL evaluates true, so it will return all rows that you selected. Anyway, I think you may need to have the whole condition in the because of joins. Other than that, I may be mistaken, I think that in past PHP 4 versions Oracle did not return the result set metadata if it did not select any rows. I think Thies could answer this because he did PHP OCI API. Regards, Manuel Lemos