proliferation of error messages

2007-05-04 Thread Mary Anderson
Hello all, My perl cgi script which runs dbi is generating error messages to the logs just about everytime dbi is called. The program appears to be running correctly. How do I keep from getting the spurious messages sent? Mary Anderson

FWD: Re: proliferation of error messages, sample of error messages

2007-05-04 Thread Mary Anderson
John Scoles wrote: What are the messages??? - Original Message - From: Mary Anderson [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Friday, May 04, 2007 1:04 PM Subject: proliferation of error messages Hello all, My perl cgi script which runs dbi is generating error messages

MySQL, blobs, GIS

2006-10-11 Thread Mary Anderson
Hi all, I have a MySQL-perl-cgi-dbi application which would like to store images and GIS info. Will dbi running with DBD:MySQL support these? Thanks, Mary Anderson

RE: AutoCommit does not work

2006-08-22 Thread Mary Anderson
Artem Harutyunyan wrote: Hi, Consider, please, the following piece of code: ___ __ my $dbh = DBI-connect($dsn, $user, $pass, {RaiseError = 1,PrintError =1}); $dbh-{'AutoCommit'} = 0; my

Parse Excel repeats columns

2006-04-11 Thread Mary Anderson
Hi All, I have picked up ParseExcel and started to work with it. I am having a problem with code that essentially looks like this: for ($iR = 0; ($oWkS-{MaxRows} $iR =$oWkS-{MaxRows}, $iR++){ for ($iC=0; ($oWkS-{MaxCols} $iC =$oWkS-{MaxRows}, $iC++){ $oWkC =

DBI support transactions on MySQL 5.0?

2006-03-03 Thread Mary Anderson
Hi, MySQL supports transactions on INNOB tables. Does this mean that DBI on MySQL has transaction support? Do I have to set any variables on MySQL to support the transactions does support. mary anderson

Make database handle persist in CGI/DBI application?

2006-02-23 Thread Mary Anderson
to dereference the handle. Is there any way to make the handle persist? Would I have this trouble if I used Mason? Thanks in advance, Mary Anderson

ActivePerl/MySQL problem with dropping, creating tables

2005-09-29 Thread Mary Anderson
Hi, I am running ActivePerl 5.8.7 and MySQL 4.1 on a WindowsXP box. It won't let me drop or create a table through DBI. My code and error message are attached. Thanks Mary Anderson

Reposting of ActivePerl/MySQL problem dropping tables

2005-09-29 Thread Mary Anderson
Hi all, This is a reposting of a message. I was advised that my attached code did not make it through. Basically, I am running ActivePerl 5.8.7 and mySQL 4.1 under windows XP. Although I can handle data manipulation statements through DBI, it balks at drop table and create table