I sent out a message yesterday to the Perl Web
group describing a problem that I'm having when calling SQL_INIT in a
I'd rather do all my sql work in
first.cgi, but it's failing and returning only
this message to my browser:
'C:\Inetpub\wwwroot\cgi-bin\build_dbform.cgi' script
produced no output
After trying a few things, I finally
got it to work if I call an external perl program to do the SQL work. My
first.cgi
program is called in my browser as
"http://mnolen/cgi-bin/first.cgi" and instead of doing
the sql work in there, I had
to call a TEST.CGI to connect to the database and return a string
($string) to build my form. If I take the PERL statement
out of the call (just use - $string =
`c:\\inetpub\\wwwroot\\cgi-bin\\test.cgi`) it doesn't work. Yet, if I
run the
cgi program at a
command prompt, it works fine. Is it something with IIS4.0 that's
incompatible and doesn't know
how to associate PERL.exe with .cgi programs? Here's the
code.
first.cgi:
$string = `perl c:\\inetpub\\wwwroot\\cgi-bin\\test.cgi`; #
doesn't work if I take PERL out of the statement...
print << "ending_print_tag";
Content-type: text/html
<html>
<head>
<title> Testing CGI </title>
<background="#000000" text="#FF0000" >
</head>
<body>
<h1> Testing CGI --$string-- </h1>
</body>
</html>
ending_print_tag
test.cgi
use MSSQL::Sqllib qw(:DEFAULT :rowstyles);
$dbp = sql_init( "DIABLO2", "db_req_user", "db_req_pwd", "Monarch"
);
$requester = $dbp->sql_one("select req_name from db_request where
db_req_id = 3", SCALAR);
print $requester;
TIA,
Mike Nolen
