Re: Apache::DBI and mySQL LAST_INSERT_ID

2008-12-10 Thread Perrin Harkins
On Wed, Dec 10, 2008 at 2:27 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote: > However if Apache uses > child processes sequentially - i.e there is no danger of that child process > being used simultaneously by two requests I think I should be ok. I think > this is what Perrin was confirming? Yes, th

Re: Apache::DBI and mySQL LAST_INSERT_ID

2008-12-10 Thread Justin Wyllie
Hi Guys Thanks for all the help. I have some code which inserts something into a database and immediately (the next line) executes another sql statement with SELECT LAST_INSERT_ID() - so it is not a previous one from somewhere else in the code. My concern was that because the actual connect

Re: Apache::DBI and mySQL LAST_INSERT_ID

2008-12-10 Thread Perrin Harkins
On Wed, Dec 10, 2008 at 1:22 PM, Enno <[EMAIL PROTECTED]> wrote: > yes, but, do you really want to gamble that the second request is handled by > the same child process? and what if another request comes in between? I think you're misunderstanding his question. As I read it, he was worried that m

Re: Apache::DBI and mySQL LAST_INSERT_ID

2008-12-10 Thread Enno
Perrin Harkins wrote: On Fri, Dec 5, 2008 at 5:39 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote: The mySQL documentation for LAST_INSERT_ID says that it returns the last auto-incremented field value for 'that client'. I am not sure what the client is in a mod_perl situation with Apache::DBI?

Re: Apache::DBI and mySQL LAST_INSERT_ID

2008-12-05 Thread Perrin Harkins
On Fri, Dec 5, 2008 at 5:39 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote: > The mySQL documentation for LAST_INSERT_ID says that it returns the last > auto-incremented field value for 'that client'. > > I am not sure what the client is in a mod_perl situation with Apache::DBI? The current connectio

Apache::DBI and mySQL LAST_INSERT_ID

2008-12-05 Thread Justin Wyllie
Hi The mySQL documentation for LAST_INSERT_ID says that it returns the last auto-incremented field value for 'that client'. I am not sure what the client is in a mod_perl situation with Apache::DBI? I have an Apache child process which uses one open database connection for its lifetime. If 2 p