Hello,
>From Turbogears website I found out that mssql doesn't support offset
>query.....
read below.....
On Wed, Jun 4, 2008 at 4:20 PM, Lukasz Szybalski <[EMAIL PROTECTED]> wrote:
>
>> Paginate uses the same output from the same method, but slices the
>> result differently, that's why it is important to not use .all() (if
>> you are not on MSSQL server, because MSSQL server does not support the
>> use of offsets in queries).
>
> I took off the .all() just to see what happens and here comes the
> error. So I guess I have to use .all()?!?
>
File
"/usr/local/pythonenv/BASELINE/lib/python2.4/site-packages/SQLAlchemy-0.4.6dev_r4675-py2.4.egg/sqlalchemy/databases/mssql.py",
line 498, in do_execute
cursor.execute("SET IDENTITY_INSERT %s OFF" %
self.identifier_preparer.format_table(context.compiled.statement.table))
SystemError: 'finally' pops bad exception
Error location in template file
'/home/unique/turbogears/xxxx/xxxx/templates/activexxxx.kid'
on line 25 between columns 3 and 72:
... <span py:content="activexxxxgrid(activexxxx)">some content</span ...
> File
> "/usr/local/pythonenv/BASELINE/lib/python2.4/site-packages/SQLAlchemy-0.4.6dev_r4675-py2.4.egg/sqlalchemy/databases/mssql.py",
> line 498, in do_execute
What is interesting is the end of the traceback not the beginning, but
I suspect the error you get is because you are using MSSQL and it does
not support offsets. I know some people are working on implementing an
offest support for MSSQL to be able to use proxy results instead of
using all() on MSSQL.
I guess my question is, if wanted to use offset. How would I do it?
>Postgresql, Mysql & Oracle all support offsets.
>AFAIK Oracle doesn't. You can fake it using an embedded SQL and the implicit
>rownum-column. but that will cost performance. If you can, keep a referernce
>to the cursor around.
Lucas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
