On Lu, 2001-12-10 at 11:59, Andrew McMillan wrote: > I just construct my query in the normal way and append a LIMIT ... > OFFSET ... clause to control the finally select records. I can't do that. Some of the queries I use are complex; after you run a query you can refine it, add to results, substract from results... I use a table to build the results from initial query, then add/remove to it as needed until search is done and finally user starts to browse the results. I can't make it in one huge query. For simple queries your solution is the best, no need for a table; I assume you just save the query in a session variable. I also assume your query doesn't take more than a second to run. thanks -- Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/
