Hi,
I'm using interface to get lot's of data from different tables.. But
I have a problem.
query.addOrderBy(field);
it orders by result, but per table, not whole result. When looking at
postgresql query log, I see that it is implemented like this:
SELECT ... FROM bar1 orderBy fieldID;
SELECT ... FROM bar2 orderBy fieldID;
SELECT ... FROM bar3 orderBy fieldID;
so, of course it won't sort it right..
wouldn't it work better, if it would generate it like this:
SELECT .. FROM bar1 UNION SELECT .. FROM bar2 UNION SELECT .. FROM
bar2 order by fieldID;
or have I configured it wrong?
- Joose
--
"Always remember that you are unique, just like everyone else!"
* http://iki.fi/joose/ * [EMAIL PROTECTED] * +358 44 561 0270 *
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
