Re: [sqlalchemy] Receiving this error: sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('HYC00', u'[HYC00] [Microsoft][ODBC SQL Server Driver]Optional feature not implemented (0) (SQLBindParameter)')

2019-05-17 Thread Mike Bayer
On Fri, May 17, 2019 at 4:39 PM Alex Net wrote: > > Hello! I have been writing code that would allow me to read from an Excel > sheet and writing it in a MS SQL Database. The code was functioning well, > meaning it was running and writing all cells until it got to cell E,23 , > where it

[sqlalchemy] Receiving this error: sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('HYC00', u'[HYC00] [Microsoft][ODBC SQL Server Driver]Optional feature not implemented (0) (SQLBindParameter)')

2019-05-17 Thread Alex Net
Hello! I have been writing code that would allow me to read from an Excel sheet and writing it in a MS SQL Database. The code was functioning well, meaning it was running and writing all cells until it got to cell E,23 , where it crashes. Column E is called DueDate, and the first 22 cells print

Re: [sqlalchemy] Case Sensitivity at query time for SQL Server

2019-05-17 Thread Mike Bayer
On Fri, May 17, 2019 at 9:43 AM Massi wrote: > > Hi, > > I'm trying to issue a query in SQL Server via select(cols, cond, ...) and I > would like to add collation at query execution time for executing the query > in a case sensitive mode. > I tried this: > > cond = and_(tab.c.col3=="mystring1",

[sqlalchemy] Case Sensitivity at query time for SQL Server

2019-05-17 Thread Massi
Hi, I'm trying to issue a query in SQL Server via select(cols, cond, ...) and I would like to add collation at query execution time for executing the query in a case sensitive mode. I tried this: cond = and_(tab.c.col3=="mystring1", tab.c.col2=="mystring2") cond =

Re: [sqlalchemy] Re: Query last relation created and attributes

2019-05-17 Thread Scheck David
I really don't know why this query returns me this .. totally mysterious Le jeudi 16 mai 2019 16:27:50 UTC+2, Scheck David a écrit : > > I finished by a query like that : > > > last_statuses = aliased(statussen_table_name, > self.session.query(getattr(statussen_table_name, object_name),

Re: [sqlalchemy] InvalidRequestError: Query.limit() being called on a Query with an existing full statement - can't apply criterion.

2019-05-17 Thread Mike Bayer
you're using a Flask extension that is attempting to apply pagination, this plugin is not compatible with a textual query: File "/opt/rh/rh-python36/root/usr/lib64/python3.6/site-packages/flask_admin/contrib/sqla/view.py", line 995, in _apply_pagination On Fri, May 17, 2019 at 8:31 AM Xander

Re: [sqlalchemy] InvalidRequestError: Query.limit() being called on a Query with an existing full statement - can't apply criterion.

2019-05-17 Thread Xander Cage
here is the stack trace and there is indeed some gibberish about limit(). i did not set any limit or something so i have no idea where this comes from? Traceback (most recent call last): File "/opt/rh/rh-python36/root/usr/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__