Re: DBI and last_insert_id()

2004-06-15 Thread William R. Mussatto
Garth Webb said: > You might have better luck with this on the [EMAIL PROTECTED] list, > re: why this doesn't work. This works for me though: > > $pk = $dbh->{mysql_insertid}; > > On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote: >> Hi all. >> >> I'm writing an app in Perl / Gtk2, and I'm havin

Re: DBI and last_insert_id()

2004-06-15 Thread Garth Webb
You might have better luck with this on the [EMAIL PROTECTED] list, re: why this doesn't work. This works for me though: $pk = $dbh->{mysql_insertid}; On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote: > Hi all. > > I'm writing an app in Perl / Gtk2, and I'm having trouble with DBI's > last_

Re: DBI and last_insert_id()

2004-06-15 Thread Daniel Kasak
Paul McNeil wrote: last_insert_id() should work. You are updating using @bind_values. What is the text of that? Does it indeed create a record? @bind_values is an array of values that gets populated from my form. It has the same number of elements as the number of placeholders in my SQL, and

RE: DBI and last_insert_id()

2004-06-15 Thread Paul McNeil
last_insert_id() should work. You are updating using @bind_values. What is the text of that? Does it indeed create a record? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From

RE: DBI and last_insert_id()

2004-06-15 Thread Paul McNeil
You wrote > $pk = $dbh->last_insert_id(); I believe you can get the created ID with the query, "Select @@IDENTITY;" This returns the last created ID from the connector object. Peace -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: