Re: [Tutor] OT - SQL methodology.

Liam Clarke wrote: Hi, This is a SQL query for the advanced db gurus among you (I'm looking at Kent...) Uh oh, you're in trouble if you think I'm an "advanced db guru" :-) After I've run an insert statement, should I get the new primary key (it's autoincrementing) by using PySQLite's cursor.lastr

Re: [Tutor] OT - SQL methodology.

Brilliant, thanks Sean. On Mon, 21 Mar 2005 22:37:14 -0800, Sean Perry <[EMAIL PROTECTED]> wrote: > Liam Clarke wrote: > > Hi, > > > > This is a SQL query for the advanced db gurus among you (I'm looking at > > Kent...) > > > > After I've run an insert statement, should I get the new primary ke

Re: [Tutor] OT - SQL methodology.

Liam Clarke wrote: Hi, This is a SQL query for the advanced db gurus among you (I'm looking at Kent...) After I've run an insert statement, should I get the new primary key (it's autoincrementing) by using PySQLite's cursor.lastrowid in a select statement, or is there a more SQLish way to do this

[Tutor] OT - SQL methodology.

Hi, This is a SQL query for the advanced db gurus among you (I'm looking at Kent...) After I've run an insert statement, should I get the new primary key (it's autoincrementing) by using PySQLite's cursor.lastrowid in a select statement, or is there a more SQLish way to do this? In the SQL book