hi,
i'm having an issue with split_page_results and i'm curious if anyone has come up with a workaround. this is NOT specifically a problem with ZC, but i'm trying to use some of the ZC tools.
specifically i have an SQL statement that makes use of the UNION operator.
when i throw it through the split_page_results function, it dies.
as an example, my sql statement is:
Code:
select * from orders where orders_id = 15362
UNION
select * from orders where orders_id = 15483
when i run it through splitPageResults, the resulting sql statement that dies is:
Code:
select count(*) as total from orders where orders_id = 15362 UNION select * from orders where orders_id = 15483
now, i do NOT want to come up with a whole new paginator function, which is why i am using the split_page.
if anyone has any ideas... i am listening.
thanks.
Bookmarks