Hi, It's could be a problem with encoding, did you try to use utf8? 2017-05-23 7:58 GMT+03:00 rishi007bansod <rishi007ban...@gmail.com>:
> If instead of id_list i.e. list of ids, if I pass single parameter(not > list) > as argument as follows, > > *cursor = connection.cursor() > select_string= "INSERT INTO Person (_key, id, firstName, lastName, salary) > VALUES (322, ? , 'abcd', 'dhsagd', 1000)" > > cursor.execute(select_string, 'test') > * > I am still getting following error, > > *Traceback (most recent call last): > File "pythonOdbclist.py", line 13, in <module> > cursor.execute(select_string, id_list) > pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 1 > parameters were supplied', 'HY000')* > > I think either Ignite or pyodbc is unable to identify paramere marker *"?"* > that I have provided > > Thanks. > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Error-while-passing-arraylist-as- > argument-to-INSERT-data-into-Ignite-cache-using-pyodbc-tp13049p13079.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >