DBD-mysql - Re: InnoDB problem - INSERT works, SELECT gets 0 rows

Posted on Mon Apr 7 04:33:07 2008 by nmatchan in response to 7584 (See the whole thread of 3)
Re: InnoDB problem - INSERT works, SELECT gets 0 rows
Clint, Many many thanks. I've change AutoCommit=>0 to AutoCommit=>1 and I now seeing the record data in the InnoDB table. I tried inserting $sth->commit after the $sth->execute but perl can't locate the 'commit' method in the DBI::st package. I think this is just a syntax problem so it should be to diffcult to chase up. Once again, many thanks for your assistance. Regards, Neil M
Write a response