Odoo Help

0

Typecast int to char?

By
evon_dun
on 7/3/13, 7:49 AM 2,305 views

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!

2
patrick
On 7/3/13, 10:51 AM

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 ( ' ).

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 7/3/13, 7:49 AM
Seen: 2305 times
Last updated: 3/16/15, 8:10 AM