Skip to Content
This question has been flagged
postgresqlchangetypetypecast
1 Respondre
8252 Vistes
Avatar
evon_dun

I am trying to work on a query in openerp 6.1, but it gives an error:

ProgrammingError: operator does not exist: character varying = integer LINE 1: SELECT debit,credit FROM account_move_line WHERE ref = 434 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

And my query:

move_obj = self.pool.get('account.move.line')
cr.execute("SELECT debit,credit FROM account_move_line WHERE  ref = %s",(move_id,))

Please help i tried looking at the typecast methods tried few but it always have some error or probably the module to be imported was missing. Its damn too urgent!

Avatar
Descartar
Avatar
patrick
Best Answer

The issue is that ref expects a string. In SQL, strings need to be surrounded by single quotes ( ' )

So the following (add a ' before and after %s) should do the trick:

move_obj = self.pool.get('account.move.line')
cr.execute("SELECT debit,credit FROM account_move_line WHERE  ref = '%s'",(move_id,))

You do not get string errors, becausew you start and end with a double quote ( " ), which does NOT end with a single quote ( ' ).

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Huge language change bug - need help asap Solved
language postgresql change bug
Avatar
Avatar
2
d’abr. 15
5342
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released
postgresql
Avatar
0
de febr. 25
2789
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
Avatar
2
de gen. 25
9884
space characters are femoved directly after typen them
type
Avatar
0
de jul. 24
1858
Odoo backend to Google Data Studio Solved
postgresql
Avatar
Avatar
2
de gen. 24
10139