Uff, lass doch dieses Q = Q & ... weg. ;-)
q = "SELECT * FROM" &_
" tblExperten" &_
" INNER JOIN tblExpertenSchwerpunkteZusatz" &_
....
Gruss
Roman Pittroff
Consulting
Bangkok, Thailand
-----Original Message-----
From: Markus Sandke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 5:09 PM
To: ASP Diskussionsliste fuer Anfaenger
Subject: [aspdebeginners] AW: RE: AW: RE: AW: RE: AW: RE: Performance
Frage -- - Falls jemand h elfen kann
Hallo!
Ich habe das jetzt mal ausprobiert und bekomme folgende Fehlermeldung
Set rsName=Server.CreateObject("ADODB.RecordSet")
q = "SELECT * FROM"
q = q & " tblExperten"
q = q & " INNER JOIN tblExpertenSchwerpunkteZusatz"
q = q & " ON (E_ID = ES_E_ID)"
q = q & " INNER JOIN tblExpertenSchwerpunkte"
q = q & " ON (ES_S_ID = S_ID)"
q = q & " AND S_ID = 1"
q = q & " INNER JOIN tblUnterlagenExperten"
q = q & " ON (E_ID = UE_ID)"
q = q & " INNER JOIN tblUnterlagen"
q = q & " ON (UU_ID = ES_E_ID)"
q = q & " AND U_ID = 4"
'q = q & " INNER JOIN Zwischentabelle3 F"
'q = q & " ON A.ID3 = F.zID"
'q = q & " INNER JOIN Nochnetabelle G"
'q = q & " ON F.zsID = G.sID"
'q = q & " AND C.value > 500000"
q = q & " WHERE A.Datum >= '01/01/2001'"
60 rsName.Open q , conn, adOpenStatic
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender
Operator) in Abfrageausdruck '(E_ID = ES_E_ID) INNER JOIN
tblExpertenSchwerpunkte ON (ES_S_ID = S_ID) AND S_ID = 1 INNER JOIN
tblUnterlagenExperten ON (E_ID = UE_ID) INNER JOIN tblUnterlagen ON
(UU_ID = ES_E_ID) AND U_ID = 4'.
/webExperten/queryTest2.asp, line 60
| Oft Gefragtes: http://www.aspgerman.com/aspgerman/faq/
| [aspdebeginners] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdebeginners/ = Listenarchiv
| Sie knnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdebeginners.asp
