that is because you are calling a script using cgi from the command prompt.
that's really a question for a perl/cgi group.
cgi's are intended to be run from the web.
i think you can just press Ctrl+D (or Ctrl+Z - can't remember which) when you get that
prompt to continue.
----- Original Message -----
From: "c cw_1" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 2:28 PM
Subject: DBI problem
> Hi,
>
> I tried to connect to the database, when I compiled it, it replied with
> "(offline mode: enter name=value pairs on standard input)" - What is
> this meant?
>
> Below is my code:
>
> #!/usr/bin/perl -w
> use strict;
> use CGI;
> use DBI;
>
> my $dbh;
> my $sth;
> my @row;
>
> my $form = new CGI;
>
>
> print $form->header;
> print "<html><body>";
> print "ready to connect<p>";
> my $database = "loc_data";
> my $username = "mysql";
> my $password = "mysql";
>
>
> #open connection to Access database
> $dbh = DBI->connect("DBI:mysql:$database", "$username", "$password")
> or die "Couldn't connect to database: " . $dbh->errstr;
>
> # print "connected<p>";
>
> #construct SQL statement
> ##$sqlstatement = "SELECT * from tld_data";
>
> # print "selected<p>";
>
> #prepare and execute SQL statement
> $sth = $dbh->prepare("SELECT * from tld_data") or die "Can't prepare SQL
> statement: " ;
>
> # print "prepared<p>";
>
> $sth->execute || print "Could not execute SQL statement, maybe invalid?";
>
> #print "<p>ready to output";
>
> #output database results
> while (@row=$sth->fetchrow_array)
> { print "@row\n<br>" }
>
>
> #vprint "hello";
> #close datbase
>
> $dbh->disconnect();
> $sth -> finish;
> print $form->end_html;
>
>
> Thanks in advance,
> Connie
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
