Re: [SQLObject] Select does not work with some fieldname

2009-11-10 Thread Petr Jakeš
2009/11/10 Wolfgang Morawetz > Petr Jakeš schrieb: > > > > Maybe you can printout the names SQLObject reads from the database > > and than use this names: > > for col in TCountry.sqlmeta.columnList: > > print col > > > > Or maybe: > > > > print col.origName, col.dbName > > > >

Re: [SQLObject] Select does not work with some fieldname

2009-11-08 Thread Petr Jakeš
> please help. > how do i this SQL > SELECT * > FROM `TAthlet` > WHERE TCountry_id = 'AUT' > > The table "TAthlet" have this fields: > TUnion_id > id > short > name > TGender_id > TGoup_id > TCountry_id > > This does not work: > from sqlobject import * > sqlhub.processConnection = > connectionForUR

[SQLObject] Select does not work with some fieldname

2009-11-08 Thread Wolfgang Morawetz
Hi, please help. how do i this SQL SELECT * FROM `TAthlet` WHERE TCountry_id = 'AUT' The table "TAthlet" have this fields: TUnion_id id short name TGender_id TGoup_id TCountry_id This does not work: from sqlobject import * sqlhub.processConnection = connectionForURI('mysql://archer:xxx...@localho