Pagination problems resulting in a mssql order_by error

What steps will reproduce the problem?
1. >> Inserting FormAlchemy in an existing project
2. >> In a view, using Pylons CRUD interface,  you got than 20 rows in a table
3. >> When you want to access datas by clicking on the pagination number

What is the expected output? What do you see instead?

The excepted output is to get the following row ordered by the primary key. 
But it raise the error :
'MSSQL requires an order_by when using an offset.'

What version of the product are you using? On what operating system?

Lastest version of FA on Windows XP
with Pylons1.0
SqlAlchemy 0.6

Please provide any additional information below.

Is it a problem of MsSql ?Or does FA not support pagination?If true where can i 
modify it ?

Original issue reported on code.google.com by thebangc...@gmail.com on 9 May 2011 at 5:50

pombreda / formalchemy

Pagination problems resulting in a mssql order_by error #164