hallo renee, habe es 1:1 übernommen und die tabellen-print zeile eingefügt. ist sie dort richtig plaziert???
funktioniert aber immer noch nicht.
hier mein jetziges script:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
#! c:/perl/bin/perl -w
use strict;
use CGI qw(:standard);
use DBI;
#my $dbh = DBI->connect('DBI:ODBC:db1');
my $sqlstatement=qq§SELECT Tabelle1.Adresse, Name, Telefon, Tabelle2.Rechnungsbetrag
FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§;
#my $sth = $dbh->prepare($sqlstatement);
#$sth->execute || die "Could not execute SQL statement ... maybe invalid?";
print header(-type => 'text/html'), start_html(-title => 'Antwort');
print h3('Treffer'), hr();
my @row;
#while (@row=$sth->fetchrow_array)
#{print "<p>@row</p>\n"}
print '<table>';
while (@row=$sth->fetchrow_array){
print '<tr>';
print '<td>',$_,'</td>' for(@row);
print '</tr>';
}
print '</table>';
print qq§</body>\n</html>§;
hier die neuen error-log zeilen:
[Thu Jan 08 10:23:31 2004] [notice] Parent: Created child process 936
[Thu Jan 08 10:23:32 2004] [notice] Child 936: Child process is running
[Thu Jan 08 10:23:32 2004] [notice] Child 936: Acquired the start mutex.
[Thu Jan 08 10:23:33 2004] [notice] Child 936: Starting 250 worker threads.
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] (Might be a runaway multi-line && string starting on line 9), referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] (Do you need to predeclare FROM?), referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] Operator or semicolon missing before § at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:57:39 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 22., referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] (Might be a runaway multi-line && string starting on line 9), referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] (Do you need to predeclare FROM?), referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] Operator or semicolon missing before § at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:22 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:23 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:58:23 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 22., referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] (Might be a runaway multi-line && string starting on line 9), referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] (Do you need to predeclare FROM?), referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Operator or semicolon missing before § at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§", referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Global symbol "$sth" requires explicit package name at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 23., referer:
http://localhost/kunden.html
[Thu Jan 08 10:59:41 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 30., referer:
http://localhost/kunden.html
gruss uwe
Edit renee: code-Tags eingefügt\n\n
<!--EDIT|renee|1073556926-->