[eluser]quasiperfect[/eluser]
thanks for the response i will try that
i'm doing this because i can get the query without the limit of the pagination part in a string
then run the query to see how many rows i have, set the number of rows in a session var
then run the query with limits to get the results so i don't have to do two separated procedures for this.