|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Help me anyone?
I am running winNT.40 work station, with option pack and PWS. I have insstalled mysql-shareware version. I have installed from ActiveState Perl- build613. I have DBI, DBD-mysql, DBD-ODBC modules installed I have created a data base "people' with a table "phones" in mysql. I HAVE THIS CGI SCRIPT IN THE CGI-BIN DIR. of PWS -------- #!/usr/bin/perl -w # print-table.cgi - print contents of a table as HTML print "HTTP/1.0 200 OKn"; print "Content-Type: text/htmlnn"; use DBI; use CGI qw(:standard *table :html3); print header(), start_html("All the People"), start_table(); $dbh = DBI->connect("DBI:mysql eople", "ugtn5", "sada", { RaiseError => 1 }); $sth = $dbh->prepare("SELECT * FROM phones"); while (@row = $sth->fetchrow_array) { print Tr(Td( [ @row ] )); } print end_table(), end_html(); $sth->finish(); $dbh->disconnect(); --------------- I get a meessage, 'the cgi script produced no output' when I run this script . What other modules am I missing? Do I need a special ODBC administator.? "DBI:ODBC:xxx.mdb" works OK mysql and php scripts that I have, work OK. What am I doing wrong? What is missing? |
|
#2
|
|||
|
|||
|
does it work properly if you run it from the command line? what does it say?
|
|
#3
|
|||
|
|||
|
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Imo:
does it work properly if you run it from the command line? what does it say?[/quote] I am getting no output. There are no error messages. This is what I get: 'F:Inetpubwwwrootcgi-bintark.cgi' script produced no output Need I configure ODBC as I do for Access databases? Thanks |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > help : dbi:mysql:mydb |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|