Thread CGI+HTML+DB durchsuchen+TXT generieren (84 answers)
Opened by lolipop 999 at 2006-12-03 10:38

lolipop 999
 2006-12-11 19:55
#9167 #9167
User since
2006-04-07
150 Artikel
BenutzerIn
[default_avatar]
das kommt dabei raus

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
Content-Type: text/html; charset=ISO-8859-1

[Mon Dec 11 18:48:24 2006] daba71.cgi: DBD::ODBC::db prepare failed: [Microsoft]
[ODBC Microsoft Access Driver] Syntaxfehler in FROM-Klausel. (SQL-42000)(DBD: st
_prepare/SQLPrepare err=-1) at daba71.cgi line 88.
<h1>Software error:</h1>
<pre>Error: couldn't prepare sql: [Microsoft][ODBC Microsoft Access Driver] Synt
axfehler in FROM-Klausel. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1)
SELECT Tabelle1.Kundennummer, Tabelle1.Name,
Tabelle1.Telefon, Tabelle2.Rechnungsbetrag
FROM Tabelle2 JOIN Tabelle1
WHERE Tabelle2.Kundennummer = Tabelle1.Kundennummer
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error message
and the time and date of the error.

</p>
[Mon Dec 11 18:48:24 2006] daba71.cgi: Error: couldn't prepare sql: [Microsoft][
ODBC Microsoft Access Driver] Syntaxfehler in FROM-Klausel. (SQL-42000)(DBD: st_
prepare/SQLPrepare err=-1)
[Mon Dec 11 18:48:24 2006] daba71.cgi: SELECT Tabelle1.Kundennummer, Tabelle1.Na
me,
[Mon Dec 11 18:48:24 2006] daba71.cgi: Tabelle1.Telefon, Tabelle2.Rechnungsbetra
g
[Mon Dec 11 18:48:24 2006] daba71.cgi: FROM Tabelle2 JOIN Tabelle1
[Mon Dec 11 18:48:24 2006] daba71.cgi: WHERE Tabelle2.Kundennummer = Tabelle1.Ku
ndennummer


Danke für die Hilfe

lolipop 999

View full thread CGI+HTML+DB durchsuchen+TXT generieren