How to solve TypeError: cannot concatenate 'str' and 'int' objects?

Question

I am trying to retrieve a list in my database. My statement is this:
cr.execute("select es.* from student_resource es where es.date between '"+str(date_from)+"' and '"+str(date_to)+"'")  where *date_from* and* date_to* are of type *fields.date* but when when executed, that is i am trying to access my view, it says:
*TypeError: cannot concatenate 'str' and 'int' objects*
What did i miss with my statement?

Emipro Technologies Pvt. Ltd. · Accepted Answer

Hello,
As your fields are fields.date then you do not need to convert into string. Please write your query as like below.
cr.execute("select es.* from student_resource es where es.date between '" + date_from + "' and '" + date_to + "' ")
*or*
cr.execute("select es.* from student_resource es where es.date between '%s' and '%s' " %(date_from, date_to) )
*Update : or*
query = "select es.* from student_resource es where es.date between '%s' and '%s' " %(date_from, date_to)
cr.execute(query)
When you

Akhil P Sivan · Answer

I think you can use the *to_date() *in psql for that.
Try like this:
cr.execute("select es.* from student_resource es where es.date between to_date(date_from, 'YYYY/MM/DD') and to_date(date_to, 'YYYY/MM/DD')")
*OR*
cr.execute("select es.* from student_resource es where es.date between to_date("+str(date_from)+", 'YYYY/MM/DD') and to_date("+str(date_to)+", 'YYYY/MM/DD') ")

Marvin Taboada · Answer

Quoting Psycopg official references (see here) [1]  :
Psycopg casts Python variables to SQL literals by type. Many standard Python types are already adapted to the correct SQL representation. Don't manually add single quotes depending of the data type, let Psycopg do that for you.
cr.execute(
"""INSERT INTO some_table (an_int, a_date, a_string) VALUES (%s, %s, %s);""",
(11, datetime.date(2007, 07, 27), "Odoo rocks!"))

[1] http://initd.org/psycopg/docs/usage.html

Related Posts	Răspunsuri	Vizualizări
Set 0 for a 'None' value which is inside a list Rezolvat list python2.7 openerp7.0	2 dec. 19	4972
How to make a dynamique _order in python ? python2.7 openerp7.0 orderby	1 mar. 15	7046
please explain this strange override super behaviour python orm python2.7 openerp7.0	0 feb. 16	3671
How to populate a one2many field from another one2many field? Rezolvat one2many python2.7 openerp7 openerp7.0	2 aug. 15	7292
How to set parent_id while creating it's child on on_change method? on_change python2.7 openerp7.0 populate	1 aug. 15	5420

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!