On Tue, Feb 12, 2008 at 08:22:17AM -0600, Mike Driscoll wrote:
> > Or, if empID is the Primary Key,
> > use it as the id:
> >
> > class tblAcctPrefs(SQLObject):
> > class sqlmeta:
> > idName = "emp_id"
> > idType = str
> > pref_name = StringCol()
> > pref_value = StringCol()
> >
> since the tables I will be using have been
> created by vendors and are outside of my control, I cannot alter the
> tables as that would break their use for other programs that access them.
My last advise was not about altering the tables but about naming of the
primary key. SQLObject requires a single-column primary key of type INT or
string, not necessary named 'id'.
Unfortunately if there are tables with multiple columns primary key you
are out of luck - SQLObject cannot handle them.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
