Sorry to take so long to reply. I've been occupied with other stuff. With
regard to your first question, exactly how much else info would be helpful?
As for the SQLObjectWithFormGlue import, it's not needed for the class...
the original class is a subclass of the form glued class, which is a
subclass of normal SQLObject, but I turned it back to a direct subclass for
the test objects to make sure it wasn't in the subclass, and it wasn't.
Thirdly, you are right, I do have other columns. Among other things, I
specifcally have to declare the UnicodeCols or they get instantiated as
StringCols. I'll attach the column defs of the title table as html to this
mail. I don't know if I made it clear in my original email, I've got a title
table, an author_title pivot table, and an author table. I can go from
author and get author.titles automagically (thanks sqlobject!) but the
reverse relation doesn't work. Hope this helps.
Thanks once again.
--Markos Kapes
On Tue, Jan 18, 2011 Oleg Broytman wrote:
> 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/ p...@phdru.name
> Programmers don't die, they just GOSUB without RETURN.
>
>
Title: SHOW FULL COLUMNS FROM title;
SHOW FULL COLUMNS FROM title;
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | int(11) | | NO | PRI | | auto_increment | select,insert,update,references | (null) |
| isbn | varchar(10) | utf8_unicode_ci | NO | MUL | | (null) | select,insert,update,references | (null) |
| booktitle | text | utf8_unicode_ci | YES | MUL | | (null) | select,insert,update,references | (null) |
| publisher | varchar(50) | utf8_unicode_ci | NO | (null) | | (null) | select,insert,update,references | (null) |
| release_date | varchar(255) | utf8_unicode_ci | YES | (null) | | (null) | select,insert,update,references | (null) |
| tag | text | utf8_unicode_ci | YES | (null) | | (null) | select,insert,update,references | (null) |
| kind_id | int(11) | | YES | MUL | | (null) | select,insert,update,references | (null) |
| edition | int(11) | | YES | (null) | | (null) | select,insert,update,references | (null) |
| type | varchar(25) | utf8_unicode_ci | YES | (null) | | (null) | select,insert,update,references | (null) |
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
