Hallo bitte der source hilft nicht viel. lasse die das SQL ausgeben und teste das in der db direct oder schicke dieses zu uns :-)
Gruss >-----Original Message----- >From: Alexander Husic [T-Online] [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, March 26, 2002 4:26 PM >To: ASP Diskussionsliste fuer Anfaenger >Subject: [aspdebeginners] Ich sehe den Wald vor lauter B�umen >nicht - oder falsche Syntax in der N�he des AND-Schl�sselwortes > > >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 > | 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
