Re: [sqlalchemy] Problem with Association Object mapping

2012-07-10 Thread Jules Stevenson
Seems I got the append wrong, the below works fine, thanks again for your help. due_con.due_user = c.user contact.due_dates.append(due_con) On Tue, Jul 10, 2012 at 8:46 AM, Jules Stevenson droolz...@googlemail.comwrote: Hi Michael, Yes, I am doing this: due_con =

[sqlalchemy] Problem with Association Object mapping

2012-07-09 Thread Jules Stevenson
Hi All, I'm trying to put together an Association Object mapping within a pylons app, but am getting the following error: OperationalError: (OperationalError) (1364, Field 'user_id' doesn't have a default value) 'INSERT INTO contact_duedate_user_association (contact_id, modded) VALUES (%s, %s)'

Re: [sqlalchemy] Problem with Association Object mapping

2012-07-09 Thread Michael Bayer
On Jul 9, 2012, at 6:08 PM, Jules Stevenson wrote: Hi All, I'm trying to put together an Association Object mapping within a pylons app, but am getting the following error: OperationalError: (OperationalError) (1364, Field 'user_id' doesn't have a default value) 'INSERT INTO