On Jan 8, 2008, at 5:42 PM, Jonathan LaCour wrote:
> > Michael Bayer wrote: > >> sure...what do your SQL logs say ? > > 2008-01-08 17:41:21,832 INFO sqlalchemy.engine.base.Engine.0x..50 > INSERT INTO task (sequence, subject, description, due_date, > reminder, private, company_id, assigned_to_id, job_id) VALUES > ((SELECT max(task.sequence) + ? AS value FROM task UNION SELECT ? > AS value), ?, ?, ?, ?, ?, ?, ?, ?) > 2008-01-08 17:41:21,833 INFO sqlalchemy.engine.base.Engine.0x..50 > [100, '100.0', 'Item One', None, None, None, None, 1, None, None] > so....its missing the outermost SELECT ? try an alias ? also, i think a CASE statement might be the better choice here to get the hardcoded "100" in there perhaps ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---