[DB-SIG] problem with SELECT
Wed, 15 Aug 2001 03:41:59 -0700
At 12:17 PM 8/15/2001 +0200, you wrote:
>On 15 Aug 2001 03:11:53 -0700, Ian wrote:
> > Hey all,
> > i'm trying to write a script that updates a database. I dont seem to have
> > any problems inserting data into the tables.
> > But I'm trying to get the ID for a the records and its not working.
> > I tried using cursor.fetchone and all i get returned is None, and i also
> > tried using cursor.execute and i just get an empty tuple.
> > The sql statement works fine when i go into postgres and run it there.
> > I've tried doing 'SELECT NEXTVAL("id_sequence")' and i also tried
> > simple like 'SELECT * FROM table'
>you should use *both* .execute() and .fetchone(). if 'c' is a cursor,
>you can then do:
> c.execute('SELECT NEXTVAL("id_sequence")')
> id = c.fetchone()
>note that you should wrap the code in a try/except block, to catch
>hope this helps,
>Federico Di Gregorio
That did it :)