Re: [SQLObject] Select error

[Oleg B. <ph...@ma...>]

On Sun, Apr 17, 2005 at 08:41:39PM -0600, Stewart Midwinter wrote:
> class Neighbourhood(SQLObject):
>     _connection = conn
>     hoodid = IntCol()
>     name = StringCol()
>     quadrant = StringCol()
>     width = FloatCol()
>     height = Float()
> 
> but I get an error:
> _mysql_execptions.OperationalError: (1054: "Unknown column
> 'neighbourhood.id' in 'field list'").
> 
> What's the solution here?  Do I need to rename my hoodid field to id? 

class Neighbourhood(SQLObject):
   idName = "hoodid"

(I don't remember if it worked in SQLObject 0.6.1; if no - use the
latest sources from Subversion repository.)

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.