On 4/8/15 9:16 PM, arash afshar wrote:
When I try to update a row using ORM in the following way, it shows
the following error:
InterfaceError: (InterfaceError) Error binding parameter 0 - probably
unsupported type. u'UPDATE table_name SET unicode_col=?, int_col=?
WHERE table_name.id = ?' ((u'abcd',), 1, 2)
I suspect the problem is that the value corresponding to unicode_col
is (u'abcd',) as opposed to a simple u'abcd'.
that is the problem.
Here is how I update the database:
1) I first query it and obtain an object representing the row that I
need --> file_row
2) I perform some checks and change the values --> file_row.int_col =
1 followed by file_row.unicode_col = u"abcd"
3) I call commit on the session
looks fine, so, I'd imagine that somehow that unicode_col = u'abcd' is
not what it seems. Either that's not what's there or something is
interfering with it after the fact.
I am pretty sure the problem is not the original type of value of the
unicode_col since the following succeeds without error:
query(TableName).filter(TableName.id ==
file_row.id).update({'unicode_col': u"abcd", 'int_col': 1})
Any idea how to fix the error?
Thanks
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.