[egenix-users] mxODBC doesn't support LIMIT in SELECT?

[Peter Bengtsson]

SQLServer uses TOP instead of LIMIT. Try TOP 5 or TOP 5,10

2008/9/2 Minh-Long Pham <minh at mipscomputation.com>:
> Hi,
>
> I've connected to my database through mx.ODBC.Windows functions
> connect() and DriverConnect().
> I was able to execute sql.execute("""SELECT count(*) FROM
> IM1_InventoryMasterfile""") but not
> sql.execute("""SELECT * FROM IM1_InventoryMasterfile LIMIT 5""").
>
> This is the error that I get:
> mx.ODBC.Error.InterfaceError: ('3700', 1017, '[Best Canada][PUX ODBC
> Driver]Unexpected extra token: 5', 7089)
>
> Windows ODBC version: 3.525.11.32.0
> Windows Python version: 2.5
>
> Why does a simple LIMIT 5 not work?
>
> Thanks,
>
> --
> Minh
>
>
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> https://www.egenix.com/mailman/listinfo/egenix-users
>



-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com