Posted on 2008-04-07 01:33:07-07 by nmatchan in response to 7584
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
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.