Hello,
Any idea why I get those errors with psycopg2 (not with psycopg1) :
SQLError: (ProgrammingError) can't adapt 'SELECT habitats.id AS habitats_id,
habitats.habitat AS habitats_habitat \nFROM habitats \nWHERE habitats.id =
%(habitats_id)s ORDER BY habitats.id' {'habitats_id': '2'}
What's strange is that I don't have this in the python console when I
issue a query ...
I'm almost sure that it's an Unicode problem (everything is in Unicode) ...
I'm connection with:
db_engine = create_engine('...', encoding='utf-8')
This fails :
form_habitats = self.params.getlist('invasive_habitats')
for hab in form_habitats:
habitat_object = query_habitat.get(hab)
(...)
If i do like this it works :
form_habitats = self.params.getlist('invasive_habitats')
for hab in form_habitats:
habitat_object = query_habitat.get(hab.decode('utf-8'))
(...)
Any enlightenment ?
Thanks,
Julien
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
