Re: [SQLObject] Joins not working...

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

On Mon, Jan 17, 2011 at 09:34:25PM -0500, Markos Kapes wrote:
> There's probably an embarrassingly obvious answer.... I have a class
> that I have written one way that fails in its joins. call it file1. I
> wrote another class to do the same thing, and it works. I've done
> diffs on the segments in question, and I still get an
> "OperationalError 1054 Column name None does not exist". Could it be
> the different connection would cause two different results?

   Probably no, but it's hard to say without looking into all related
details - tables declarations, SQL queries.

> --------fle 1---------------- DOESN'T WORK
> from sqlobject import *
> from components import db
> from SQLObjectWithFormGlue import SQLObjectWithFormGlue

   SQLObjectWithFormGlue is imported but is not used. Seems you edited
the code to post here and lost some important details.

> #_connection = db.SQLObjconnect()
> 	
> class Title(SQLObject):
>     class sqlmeta:
>         fromDatabase = True
> 
>     booktitle=UnicodeCol(default=None)

   Do you really need both fromDatabase and columns declarations? Are
there more columns that fromDatabase draws from the database?

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.