Hallo Liste,
ich habe ein kleines Problem mit einem SQL-String. Ich soll hier einen
Fehler drin haben... in der n�he des AND-Schl�sselwortes.
SET oConn = Server.CreateObject ("ADODB.Connection")
oConn.Open "DSN=dbdv2"
strSQL = "SELECT DBD_SCHEDULE.SCH_ID, DBD_SCHEDULE.SCH_D1,
DBD_SCHEDULE.SCH_DT1, DBD_SCHEDULE.SCH_D2, DBD_SCHEDULE.SCH_DT2, " & _
" DBD_SCHEDULE.SCH_MONTH,
DBD_SCHEDULE.SCH_SEASON, DBD_SCHEDULE.SCH_COUNTRY,
DBD_SCHEDULE.SCH_EVENT, " & _
" DBD_SCHEDULE.SCH_ORGANIZIER,
DBD_SCHEDULE.SCH_ZIP, DBD_SCHEDULE.SCH_ZIP_CODE, DBD_SCHEDULE.SCH_CITY,
" & _
" DBD_SCHEDULE.SCH_STREET,
DBD_SCHEDULE.SCH_CONTACT, DBD_SCHEDULE.SCH_INFO,
DBD_SCHEDULE.SCH_ORG_TYPE, " & _
" DBD_SCHEDULE.SCH_EVENT_TYPE,
DBD_SCHEDULE.SCH_STATUS, DBD_SCHEDULE.SCH_UNIT, DBD_SCHEDULE.SCH_CREW, "
& _
" DBD_STATUS.STA_STATUS, DBD_DAY_F.DAYF_DAY,
DBD_DAY_L.DAYL_DAY, DBD_MONTH.MON_MONTH, DBD_POINT_TYPE.EPOI_POINTS, " &
_
" DBD_POINT_TYPE.EPOI_IMG,
DBD_EVENTORGANIZER.EORG_NAME, DBD_EVENTORGANIZER.EORG_STREET,
DBD_EVENTORGANIZER.EORG_ID, " & _
" DBD_EVENTORGANIZER.EORG_ZIP,
DBD_EVENTORGANIZER.EORG_CITY, DBD_EVENTORGANIZER.EORG_PHONE, " & _
" DBD_EVENTORGANIZER.EORG_FAX,
DBD_EVENTORGANIZER.EORG_GSM, DBD_EVENTORGANIZER.EORG_EMAIL, " & _
" DBD_EVENTORGANIZER.EORG_WEB,
DBD_ZIP_CODE.ZIP_CODE, DBD_EVENT_TYPE.ORG_ORG, DBD_UNIT.UNI_UNIT " & _
" FROM DBD_POINT_TYPE FULL OUTER JOIN " & _
" DBD_SCHEDULE ON DBD_POINT_TYPE.EPOI_ID =
DBD_SCHEDULE.SCH_EVENT_TYPE FULL OUTER JOIN " & _
" DBD_MONTH ON DBD_SCHEDULE.SCH_MONTH =
DBD_MONTH.MON_ID FULL OUTER JOIN " & _
" DBD_EVENTORGANIZER ON
DBD_SCHEDULE.SCH_ORGANIZIER = DBD_EVENTORGANIZER.EORG_ID FULL OUTER JOIN
" & _
" DBD_EVENT_TYPE ON DBD_SCHEDULE.SCH_ORG_TYPE =
DBD_EVENT_TYPE.ORG_ID FULL OUTER JOIN " & _
" DBD_ZIP_CODE ON DBD_SCHEDULE.SCH_ZIP_CODE =
DBD_ZIP_CODE.ZIP_ID FULL OUTER JOIN " & _
" DBD_UNIT ON DBD_SCHEDULE.SCH_UNIT =
DBD_UNIT.UNI_ID FULL OUTER JOIN " & _
" DBD_DAY_L ON DBD_SCHEDULE.SCH_D2 =
DBD_DAY_L.DAYL_ID FULL OUTER JOIN " & _
" DBD_CREW ON DBD_SCHEDULE.SCH_CREW =
DBD_CREW.CRE_ID FULL OUTER JOIN " & _
" DBD_COUNTRY ON DBD_SCHEDULE.SCH_COUNTRY =
DBD_COUNTRY.COU_ID FULL OUTER JOIN " & _
" DBD_STATUS ON DBD_SCHEDULE.SCH_STATUS =
DBD_STATUS.STA_ID FULL OUTER JOIN " & _
" DBD_DAY_F ON DBD_SCHEDULE.SCH_D1 =
DBD_DAY_F.DAYF_ID " & _
" WHERE DBD_SCHEDULE.SCH_COUNTRY = "&strCOUNTRY&" AND
DBD_SCHEDULE.SCH_SEASON = "&strSEASON&" AND SCHEDULE.SCH_MONTH =
"&strMONTH&" AND DBD_SCHEDULE.SCH_ZIP_CODE = "&strZIPCODE
SET RS = oConn.Execute(strSQL) <--- Line 39
Fehlermeldung:
[Microsoft][ODBC SQL Server Driver][SQL Server]Falsche Syntax in der
N�he des AND-Schl�sselwortes.
/spln/event.asp, line 39
Wer kann mir helfen???
Gr��e,
Alexander
| 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
