[jrf-user] Counting the columns on a joined table...
Brought to you by:
joncrlsn
|
From: Mr. C. R. <c.r...@fi...> - 2002-12-02 16:11:09
|
Hello, again, I have a problem regarding jrf (thus I'm posting here...isn't it? :)) First, I use mysql w/ tomcat. We've (manually) created a custom *Domain and *Persist objects, containing the join of a 6 tables. Also implemented a custom search which returns the sub-list of a search (using "LIMIT start, end" feature of MySQL). The problem is that I want to retrieve the COUNT(*) for this search...in another words I want to compute the results size of the QUERY, but retrieve only a subset. Please, could someone give me a hint ? Thanks in advance! Cristian. -- ===================== Sincerely, c.r. Phone: +40745133096 alias: cristian at qdrei.de "I program, therefore I exist." ===================== |