No need to apologize; your help has been invaluable.
It's working well now, so it's on to joins and other challenges!
(Though I'll try not to bother you for a few days!)

Thanks again,

----- Original Message -----
From: "Oleg Broytmann" <>
Sent: Wednesday, March 4, 2009 4:22:59 PM GMT +00:00 Monrovia
Subject: Re: [SQLObject] cannot insert with Sybase

On Wed, Mar 04, 2009 at 04:13:54PM +0000, wrote:
> Hello Oleg and others,
> But if I use 'id' instead of 'title_id' I get:
> File "/diska/data/workspace/PyXtern/Bibliothek/eggs/SQLObject-0.10.4-py2.5.egg/sqlobject/", line 1203, in __init__
> File "/diska/data/workspace/PyXtern/Bibliothek/eggs/SQLObject-0.10.4-py2.5.egg/sqlobject/", line 1237, in _create
> TypeError: titles() did not get expected keyword argument 'title_id'

   Oops, my fault, sorry. You must not declare the 'id' column.

> I hope it helps if I use dots to preserve the indentation:
> =======================================
> from.sqlobject.import.*
> class.titles(.SQLObject.):
> ....title_id = IntCol()
> ....title = StringCol()
> ....class.sqlmeta:
> ........print.'class.sqlmeta'
> ........idName = 'title_id'
> ........lazyUpdate = False

   Remove 'title_id = IntCol()' from the class declaration. idName is the
only way to name the column, and 'id' is the only way to refer to the

     Oleg Broytmann    
           Programmers don't die, they just GOSUB without RETURN.

Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
sqlobject-discuss mailing list