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 http://dbi.perl.org/ http://www.google.ca/search?q=perl+DBI > Also, is there a good 'DBI with SQL with Perl' book out there? http://www.oreilly.com/catalog/perldbi/ > ================ > #!c:/activeperl/bin/perl > use strict; > use warnings; > use DBI; > use CGI qw(:standard escapeHTML); > print ("Content-type: text/html\n\n"); > use vars qw($dbh); Why are you creating a package variable here that you don't use? > my $dbh = DBI->connect('DBI:Oracle:db', 'user', 'pw'); Here you create a lexical variable with the same name as $main::dbh? http://perl.plover.com/FAQs/Namespaces.html John -- use Perl; program fulfillment -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
