Oleg, > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Oleg Broytmann > Sent: Tuesday, February 12, 2008 8:37 AM > To: sqlobject-discuss@lists.sourceforge.net > Subject: Re: [SQLObject] MS SQL pain for a newb > > 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.
That's what I figured from the docs. Thanks for confirming that and for being so kind of helpful. Mike > -- > 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 > s > ------------------------------------------------------------------------- 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
