Thread brauche dringend hilfe: wer kann mir helfen (42 answers)
Opened by sonnenprinz at 2004-01-07 19:34

sonnenprinz
 2004-01-08 12:03
#741 #741
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
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:
Code: (dl )
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&sect", 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 &sect 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&sect", 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&sect", 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 &sect 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&sect", 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&sect", 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 &sect 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&sect", 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-->

View full thread brauche dringend hilfe: wer kann mir helfen