I’m trying to implement the dynamic smart rendering with oracle.
the equivalent for LIMIT is this:
SELECT * FROM (SELECT iwfid,service_label,ROWNUM r FROM (SELECT * FROM esb_events_service_calls) WHERE ROWNUM <= 100) WHERE r > 0
[hard code meantime…0-100)
now, I’m looping the results and produce xml for the grid.
the next step is place “total_count” and “pos” parmas.
when placing “total_count” with select count(*)… which is 12000 records, I immediately getting “locator js error”…
Also I didn’t understand how can I increment the pos and count values.
I know I should pass them in querystring but I cannot find any sample of incrementing the values.
Thanks in advance