I applied your top patch. I cannot test the second issue. If you can
and want to send me a patch, I will be happy to include it. Thanks.
On Mar 3, 10:57 am, SergeyPo wrote:
> PATCH
>
> File gluon/sql.py, line #2987 in _select method of Set (SQLSet) class
> should be:
>
> return '%s %s FROM (SELEC
PATCH
File gluon/sql.py, line #2987 in _select method of Set (SQLSet) class
should be:
return '%s %s FROM (SELECT w_tmp.*, ROWNUM w_row FROM (SELECT %s FROM
%s%s%s) w_tmp WHERE ROWNUM<=%i) %s %s %s;' % (sql_s, sql_f, sql_f,
sql_t, sql_w, sql_o, lmax, sql_t, sql_w_row, sql_o)
Previoisly was:
retu
Limitby clause works when you select db.table.ALL
It must be possible to use aliases carefully to be able to select
eequired fields only.
On 28 фев, 16:02, mdipierro wrote:
> No limitby is not working on Oracle with Joins. This is because Oracle
> does not support pagination. We do it anyway us
No limitby is not working on Oracle with Joins. This is because Oracle
does not support pagination. We do it anyway using a trick (three
nested select as suggested by the oracle docs) but the trick breaks
down with joins.
On Feb 27, 11:50 am, SergeyPo wrote:
> If you remove limitby it works. I re
If you remove limitby it works. I reported this error about 6 months
ago, tried many workarounds and thought we fixed it. But somehow it
appeared at my client's site. Versions 1.65 and current 1.75
downloaded this week.
On Feb 27, 8:20 pm, Thadeus Burgess wrote:
> Just going out on a limb here.
>
Just going out on a limb here.
Have you tried the query where it selects all columns instead of just
name and komment?
-Thadeus
2010/2/27 SergeyPo :
> SELECT headers1.name, alarms1.komment FROM (SELECT w_tmp.*, ROWNUM
> w_row FROM (SELECT headers1.name, alarms1.komment FROM headers1,
> alarm
SELECT headers1.name, alarms1.komment FROM (SELECT w_tmp.*, ROWNUM
w_row FROM (SELECT headers1.name, alarms1.komment FROM headers1,
alarms1 WHERE headers1.id=alarms1.header ORDER BY headers1.id,
alarms1.id) w_tmp WHERE ROWNUM<=5) headers1, alarms1 WHERE
headers1.id=alarms1.header AND w_row > 0;
Tr
7 matches
Mail list logo
