Re: how to use sql select query with pyodbc and django ?

2019-09-18 Thread Cornelis Poppema
I am not using pyodbc, but I imagine you should %s instead of ? as parameter marker. mysql-python actually uses python interpolation to build the query instead of simply replacing the ? signs, so pyodbc might do the same. If that's the case, it makes sense the error says there are 0 parameter

how to use sql select query with pyodbc and django ?

2019-09-18 Thread leb dev
i have a django code that connect to sql server database and i am trying to select values using *like *but once i try it it crash and the system display the below error: ('The SQL contains 0 parameter markers, but 1 parameters were supplied', 'HY000') views.py from