RE: (Fwd) DBI's method for reading [row x,field y]

The same example, using Pg... # use Pg; # my $dbh = Pg::connectdb(dbname=dbname); # my $sth = $dbh-exec(SQL STATEMENT); # for (my $i = 0; $i $sth-ntuples; $i++) { # for (my $j = 0; $j $sth-nfields; $j++) { #print Value at ($i,$j): $sth-getvalue($i,$j)\n; # }} It is more concise, and more

Re: (Fwd) DBI's method for reading [row x,field y]

Yes, you are right. Sorry. Need Mail bonding? Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=listsid=396546091

AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

Hallo, I got a solution for this problem so I thought you might be interested to hear it. At Martin's advice I called Microsoft and Hans Lindgren from Microsoft Product Support confirmed the bug and found a workaround. I got the the OK from Hans Lindgren to post the summary of the case to the

Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

Alfred, Thank you for coming back here to let us know how you got on and the resolution. The answer you got from Microsoft is very interesting and it is certainly worth remembering the workaround. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Mickautsch, Alfred wrote:

Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

I am working with a perl file intended to enter a postgresql database (as user postgres), select a list of key values based on one of those values and delete any records which match the returned results. The purpose of the program is to delete inactive records from the database that are over

RE: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

It looks like you're calling commit() on the $sth instead of the $dbh. Philip Andrew Edson wrote: I am working with a perl file intended to enter a postgresql database (as user postgres), select a list of key values based on one of those values and delete any records which match the returned

Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

Please post some code, it seems like there is something wrong in purge_acnt. Line 242 and a few lines before and after should be interesting, and the lines around DBI-connect. Alexander On 28.02.2007 16:50, Andrew Edson wrote: I am working with a perl file intended to enter a postgresql

Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

yep-- Aparently postgres thinks its smarter than anyone that wants to use it and has Auto-commit ALWAYS turned on If you find a way to turn this *feature* off let me know because it is massively counter intuitive to normal operation of any other db on the planet Thanks, Martin--

RE: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

Isn't AutoCommit turned off at the database handle level? DBI-connect('dbi:xxx:', uid, pwd, {AutoCommit = 0}) Sorry, I have not been following this thread. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

Im specifically looking for the db solution as I do a fair amount of DB work Im relatively certain they buried it in one of the undocumented almost impossible to find conf files Thx, M-- --- This e-mail message (including

Re: Locale problems with bootstrapping DBD::mysql 4.001

Allard, Good news - I have a fix for this in the upcoming version 4.002, which I will be releasing later today! Thanks for reporting this to me. Kind regards, Patrick Allard Hoeve wrote: Dear Patrick, Thanks for writing and maintaining the wonderful piece of software called DBD::mysql!

Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

On 2/28/07, Martin Gainty [EMAIL PROTECTED] wrote: yep-- Aparently postgres thinks its smarter than anyone that wants to use it and has Auto-commit ALWAYS turned on If you find a way to turn this *feature* off let me know because it is massively counter intuitive to normal operation of any