From: Petr J. <pet...@tp...> - 2012-01-29 22:17:16
|
I thing I am few steps farther but new problem arised: File "/TG_web/fantomas/controllers.py", line 305, in ulozeniProdejnihoMista prodMisto.set(**slovnikArgumentu) File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/main.py", line 1123, in set self._connection._SO_update(self, args) File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 512, in _SO_update self.query(myQuery) File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 683, in query return self._dbConnection._query(self._connection, s) File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 334, in _query self._executeRetry(conn, conn.cursor(), s) File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 329, in _executeRetry return cursor.execute(query) UnicodeEncodeError: 'ascii' codec can't encode character u'\xed' in position 101: ordinal not in range(128) ============= set method start =============== <type 'str'> telKontaktniOsoby <type 'unicode'> +420734803579 <type 'str'> kontaktniOsobaPrijmeni <type 'unicode'> Zburník <type 'str'> nazevKontaktMistaPoruchy <type 'unicode'> recepce <type 'str'> psc <type 'unicode'> 28835 <type 'str'> mesto <type 'unicode'> Nymburk <type 'str'> geocodeAccuracy <type 'str'> Z <type 'str'> adresa2 <type 'unicode'> <type 'str'> adresa1 <type 'unicode'> Sportovní 1801 <type 'str'> zemDelka <type 'unicode'> 15.058984 <type 'str'> zemSirka <type 'unicode'> 50.178441 <type 'str'> elektrinaZaRokBezDph <type 'unicode'> 2356 <type 'str'> kontaktniOsobaJmeno <type 'unicode'> Tomáš <type 'str'> cisloSignysPartnera <type 'unicode'> 34 <type 'str'> telReseniPoruchy <type 'unicode'> +420325517801 <type 'str'> nazevProdejnihoMista <type 'unicode'> SC Nymburk <type 'str'> dnuRokOtevreno <type 'unicode'> 360 <type 'str'> najemZaRokBezDph <type 'unicode'> 10400 ============ _SO_update start ===================== <type 'unicode'> tel_kontaktni_osoby <type 'unicode'> +420734803579 <type 'unicode'> kontaktni_osoba_prijmeni <type 'unicode'> Zburník <type 'unicode'> nazev_kontakt_mista_poruchy <type 'unicode'> recepce <type 'unicode'> psc <type 'unicode'> 28835 <type 'unicode'> mesto <type 'unicode'> Nymburk <type 'unicode'> geocode_accuracy <type 'str'> Z <type 'unicode'> adresa2 <type 'unicode'> <type 'unicode'> adresa1 <type 'unicode'> Sportovní 1801 <type 'unicode'> zem_delka <type 'unicode'> 15.058984 <type 'unicode'> zem_sirka <type 'unicode'> 50.178441 <type 'unicode'> elektrina_za_rok_bez_dph <type 'unicode'> 2356 <type 'unicode'> kontaktni_osoba_jmeno <type 'unicode'> Tomáš <type 'unicode'> cislo_signys_partnera <type 'unicode'> 34 <type 'unicode'> tel_reseni_poruchy <type 'unicode'> +420325517801 <type 'unicode'> nazev_prodejniho_mista <type 'unicode'> SC Nymburk <type 'unicode'> dnu_rok_otevreno <type 'unicode'> 360 <type 'unicode'> najem_za_rok_bez_dph <type 'unicode'> 10400 print myQuery: UPDATE prodejni_mista SET tel_kontaktni_osoby = ('+420734803579'), kontaktni_osoba_prijmeni = ('Zburník'), nazev_kontakt_mista_poruchy = ('recepce'), psc = ('28835'), mesto = ('Nymburk'), geocode_accuracy = ('Z'), adresa2 = (''), adresa1 = ('Sportovní 1801'), zem_delka = ('15.058984'), zem_sirka = ('50.178441'), elektrina_za_rok_bez_dph = ('2356'), kontaktni_osoba_jmeno = ('Tomáš'), cislo_signys_partnera = ('34'), tel_reseni_poruchy = ('+420325517801'), nazev_prodejniho_mista = ('SC Nymburk'), dnu_rok_otevreno = ('360'), najem_za_rok_bez_dph = ('10400') WHERE id = (19) print repr(myQuerry) u"UPDATE prodejni_mista SET tel_kontaktni_osoby = ('+420734803579'), kontaktni_osoba_prijmeni = ('Zburn\xedk'), nazev_kontakt_mista_poruchy = ('recepce'), psc = ('28835'), mesto = ('Nymburk'), geocode_accuracy = ('Z'), adresa2 = (''), adresa1 = ('Sportovn\xed 1801'), zem_delka = ('15.058984'), zem_sirka = ('50.178441'), elektrina_za_rok_bez_dph = ('2356'), kontaktni_osoba_jmeno = ('Tom\xe1\u0161'), cislo_signys_partnera = ('34'), tel_reseni_poruchy = ('+420325517801'), nazev_prodejniho_mista = ('SC Nymburk'), dnu_rok_otevreno = ('360'), najem_za_rok_bez_dph = ('10400') WHERE id = (19)" Can you send me your suggestions please? Thanks Petr |