Re: time zones?

2002-04-12 Thread Erik Rantapaa
type as a convenient way to keep tabs on when a row was modified, if doing date arithmetic on the column is a concern. Erik Rantapaa [EMAIL PROTECTED] On Fri, Apr 12, 2002 at 09:26:33AM -0400, Bradley Brown wrote: I would like to second this notion if I may. I was up until midnight (EST) last night

last_insert_id() issue w/ DBI

2001-06-12 Thread Erik Rantapaa
-prepare(UPDATE ... WHERE k = ?) succeeds $sth-execute(xxx) succeeds $sth-{mysql_insertid} is undefined I've written a C program to test this query, and I can't get it to fail, even with multiple concurrent queries running. Has anyone seen this problem before? Erik Rantapaa [EMAIL

Re: last_insert_id() issue w/ DBI

2001-06-12 Thread Erik Rantapaa
On Tue, Jun 12, 2001 at 04:47:47PM -0500, Paul DuBois wrote: Try using: $dbh-do (UPDATE ... WHERE k = ?, undef, xxx) and then access $dbh-{mysql_insertid} to see if you get a different result. I suspect perhaps not, but it's something to try. Unfortunately I get the same result.