sql issue in split_page_results with custom query using UNION

[carlwhat]

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:

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:

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.