Hi all, I am using Pylons, & SQLAlchemy (via PYODBC) to connect through to an MSSQL database. In particular, I have been trying to use Christoph Haas' alternative Paginator (http://workaround.org/pylons/ paginator/paginator.html) webhelper, which looks great.
I can get it to show pagination links for a list of records coming from a mapped Class object, but when I try to use one of the pagination links, I get an error, because the pagination webhelper in Pylons sends a SELECT statement to the database, passing a LIMIT & and OFFSET value. Unfortunately, unlike many other database engines (eg MySQL) , SQL Server does not have OFFSET in it's SQL syntax. My implementation does need pagination, & I am stuck having to use SQL Server... Has anyone managed to get pagination going on Pylons using SQL Server as the DB engine? If so, can you explain how you got around the fact that MSSQL can't handle SQL requests involving LIMIT & OFFSET? Any help would be greatly appreciated! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
