;ll have to run that kind of query to achieve at least some decent performance.Regards,Dan.
On 7/21/06, DavidA <[EMAIL PROTECTED]> wrote:
> > On Thu, 2006-07-20 at 17:34 -0400, Dan Hristodorescu wrote:> > >> > > and for SQL 2000 should look like this:> > >>
d the ORDER BY.
Having those accessible it becomes a simple matter of a different assembly of the final SELECT string.I will wait for the new code to be committed.Regards,Dan.
On 7/20/06, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote:
On Thu, 2006-07-20 at 17:34 -0400, Dan Hristodorescu wrot
Hi Ivan,I looked in the code and it seems that QuerySet class needs some serious refactoring to support MSSQL paging.For SQL 2005 the SQL string should look like this:WITH myTable AS(SELECT fields, ROW_NUMBER() OVER (order by orderclause) AS RowNumber FROM table)
SELECT * FROM myTable WHERE RowNumb
Hi Filipe,Have you tried this?http://www.egenix.com/files/python/mxODBC.htmlFor commercial use you might have to pay for it but should run on Linux.
There is also this one (SWIG based):https://sourceforge.net/projects/pyodbI cannot say anything about any of them, at work I'm forced to use Windows
