Am Montag, 19. März 2007 schrieb Oleg Broytmann: > On Mon, Mar 19, 2007 at 04:48:27PM +0100, Ferdinand Gassauer wrote: > > simplified (the PK's must be lpadded with '0' to the maxmum length of the > > PK) select pk1||pk2||pk3 as id, ... other columns.... > > > > IMHO idName could support this syntax. > > You can try to implement this, but I doubt it would be easy. SQLObject > fetches rows from the DB by id: > > SELECT id FROM table WHERE condition; > SELECT * FROM table WHERE id = ...; > > You have to change this, and change id autoincrement, and all that... > > Oleg.
thanks 1) the soultion "concat of PK's" works for me, because sqlobject does not "know" anything about the key, and the way I constructed it the key is unique. in my case the rows are fetched with a where clause, which uses the first PK column, so its fast too. 2) as this solution is mainly for views and other read only tables so there is no need for autoincrement etc. I am far away from being able to modify complex python scripts. So what I could do is to send you a documentation for the workaround, if you want to add this to http://sqlobject.org/SQLObject.html -- cu Ferdinand ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
