Federico Di Gregorio wrote:
Il giorno ven, 17/03/2006 alle 21.02 +1000, Timothy Smith ha scritto:
curpg.execute("""SELECT till_name,till_float
FROM till_config
JOIN transactions
USING (id)
WHERE for_venue = %s""", (Venue,))
Interesting. Try the following code, please:
import psycopg2.extensions
print Venue
print type(Venue)
print psycopg2.extensions.adapt(Venue)
and post the results.
federico
------------------------------------------------------------------------
_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
output as requested
Mad Cow
<type 'unicode'>
Traceback (most recent call last):
File "DutyShift.py", line 19, in ?
Main.Main()
File "/usr/home/timothy/Projects/DutyShift/trunk/python/Main.py", line
4163, in Main
PubWareApp().MainLoop()
File
"/usr/local/lib/python2.4/site-packages/wx-2.6-gtk2-ansi/wx/_core.py",
line 7473, in __init__
self._BootstrapApp()
File
"/usr/local/lib/python2.4/site-packages/wx-2.6-gtk2-ansi/wx/_core.py",
line 7125, in _BootstrapApp
return _core_.PyApp__BootstrapApp(*args, **kwargs)
File "/usr/home/timothy/Projects/DutyShift/trunk/python/Main.py", line
4135, in OnInit
frame = MainFrame(None, -1, 'Duty Shift tool - v0.9.7 Beta')
File "/usr/home/timothy/Projects/DutyShift/trunk/python/Main.py", line
3956, in __init__
Return =
UpdateSQL.UpdateConfig(self,self.TillDetails,self.RefusedEntry,self.Competitors,self.Reads,self.Venue)
File "/usr/home/timothy/Projects/DutyShift/trunk/python/UpdateSQL.py",
line 339, in UpdateConfig
print psycopg2.extensions.adapt(Venue)
psycopg2.InterfaceError: can't encode unicode string to latin-1
|
