Stu has asked for the wisdom of the Perl Monks concerning the following question:
This works fine from the command line... no problems connecting to database or with sql statement, all html codes correct and accounted for. When I invoke it in a browser I get: CGI Error... Can't call method "Sql" on an undefined value at C:\InetPub\wwwroot\cgi-bin\library.pl line 7 Is this a Perl problem or an IIS (again, forgive me) problem? Any advice gratefully recieved.use CGI qw(-no_debug :standard); use Win32::ODBC; $db = new Win32::ODBC("LIB"); $stmt = "SELECT * FROM Library WHERE Number > 1800"; $rc = $db->Sql($stmt); die qq(SQL failed "$stmt": ), $db->Error(), qq(\n) if $rc; print header(), start_html("Test Library"); while($db->FetchRow()) { @Data = $db->Data("Number","Title"); print "$Data[0] $Data[1]<br>\n"; } print end_html(); $db->Close();
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Combining ODBC & CGI
by chromatic (Archbishop) on Feb 03, 2000 at 02:16 UTC | |
by Stu (Initiate) on Feb 03, 2000 at 03:11 UTC |