Re: DBI and fetchrow

2004-05-27 Thread Jan Eden
MCMULLIN, NANCY wrote on 26.05.2004: >Does anyone know why this script hangs when it's executed? It's >probably due to the complex select statement, but I'm not sure how >to make it work. > >Also, is there a good 'DBI with SQL with Perl' book out there? > John already recommended O'Reilly's 'Pr

Re: DBI and fetchrow

2004-05-26 Thread Ramprasad A Padmanabhan
Did you try the sql directly on sql prompt If that works, then the hanging has nothing to do with the query itself. Ram On Thu, 2004-05-27 at 01:54, MCMULLIN, NANCY wrote: > Does anyone know why this script hangs when it's executed? It's probably due to > the complex select statement, but I'm n

Re: DBI and fetchrow

2004-05-26 Thread John W. Krahn
Nancy McMullin wrote: > > Does anyone know why this script hangs when it's executed? It's > probably due to the complex select statement, but I'm not sure how > to make it work. Sorry, I don't know much about DBI but perhaps these will help: http://lists.perl.org/showlist.cgi?name=dbi-users ht

DBI and fetchrow

2004-05-26 Thread MCMULLIN, NANCY
Does anyone know why this script hangs when it's executed? It's probably due to the complex select statement, but I'm not sure how to make it work. Also, is there a good 'DBI with SQL with Perl' book out there? #!c:/activeperl/bin/perl use strict; use warnings; use DBI; use CG