Re: Apache::DBI

2007-02-04 Thread Octavian Rasnita
Ok, I think I understand. I use last_insert_id() right after making the insert and store it into a variable and usually I just need to insert some records in another table right after this, but then I won't need it anymore, so I don't need to store it. I assume that if I use the same $dbh ref

Re: Apache::DBI

2007-02-04 Thread Clinton Gormley
On Sun, 2007-02-04 at 11:37 +0200, Octavian Rasnita wrote: > Ok, I think I understand. > I use last_insert_id() right after making the insert and store it into a > variable and usually I just need to insert some records in another table > right after this, but then I won't need it anymore, so I d

Re: Apache::DBI

2007-02-04 Thread Perrin Harkins
On 2/4/07, Rick Apichairuk <[EMAIL PROTECTED]> wrote: When the user clicks submit, the data in the form is submitted to your program which will then lock the table for write and insert the record. Your program then selects the last insert id and unlocks the table so others can write to it. Just