[sqlalchemy] Re: DataError inserting CURRVAL in an inline query with SQLAlchemy and SQLSoup

2009-02-19 Thread Jeff Cook
This worked after using func() to pass currval and making literal escaped single-quotes, like this: func.currval('users_user_id'). Thank you everyone for the help. On Mon, Feb 16, 2009 at 11:58 PM, jo jose.soa...@sferacarta.com wrote: You cannot pass currval('users_user_id_seq') as a parameter

[sqlalchemy] Re: DataError inserting CURRVAL in an inline query with SQLAlchemy and SQLSoup

2009-02-16 Thread Michael Bayer
use func.currval(literal_column('users_user_id_seq')).though I'm not sure how SQLSoup is going to pass that in, its what *should* work. On Feb 16, 2009, at 7:03 PM, Jeff Cook wrote: Hi all, I want to use the return value of a CURRVAL call as the value of a column in a row I'm

[sqlalchemy] Re: DataError inserting CURRVAL in an inline query with SQLAlchemy and SQLSoup

2009-02-16 Thread jo
You cannot pass currval('users_user_id_seq') as a parameter value, you have to pass an integer value instead. I solved this problem in this way: INSERT INTO employees (employee_user_id, employee_id, employee_first_name, employee_last_name, employee_address, employee_city, employee_state,