I'm not sure I understand what you're looking for...you want the column to remain NULL after an insert?
Then take off the default from the column definition and make it a datetime field instead of a timestamp. On Jan 10, 2008 9:15 PM, deanH <[EMAIL PROTECTED]> wrote: > > Hello, > > I am having a problem inserting an object into a MS SQL table that > contains a timestamp field (now) that is generated automatically - > sqlalchemy is defaulting this column to None and when it is generating > the SQL insert. Is there a way to configure the mapper so that it > ignores specific columns? > > I looked at the related topic below, but that is resolved by using a > sqlalchemy construct specific to primary keys, and i have not seen one > that is designated for timestamps. > > http://groups.google.com/group/sqlalchemy/browse_thread/thread/749c55a835b7458/51b38f4b08d31d6f?lnk=gst&q=column+exclude#51b38f4b08d31d6f > > I am new to sqlalchemy so I may be going about this the wrong way, but > my attempts at overriding with a reflected column were similarly > unsuccessful. > > Column('now', MSTimeStamp, nullable=False) > > Any thoughts on how to exclude columns from generated inserts? > > cheers > dean > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---