Hallo Liste,
ich muss meine ersten ehschritte in VBS unternehmen... komme aber nicht
so recht weiter.
Bei folgendem Code klemmts in der Letzen Zeile.... warum??
SET oConn = CreateObject ("ADODB.Connection")
oConn.Open "Driver={SQL Server};" & _
"Server=(local);" & _
"Database=dbdv2;" & _
"Uid=sa;" & _
"Pwd=xxxxxx;"
strSQL = "dbdTA1.ta1TACH, dbdSCHEDULE.schDTF, dbdTA2.ta2TACH,
dbdSCHEDULE.schDTL, dbdMON.monMON, dbdSEASON.seaSEASON, "&_
"dbdCOUNTRY.couCOUNTRY,
dbdEVENTTYPE.evtORGA, dbdEVENTPOINTS.evpPOINTS, dbdSTATUS.staSTATUS,
dbdSCHEDULE.schMAIL, "&_
"dbdSCHEDULE.schID, dbdSCHEDULE.schEVENT
"&_
"FROM dbdSCHEDULE FULL OUTER JOIN "&_
"dbdSTATUS ON dbdSCHEDULE.schSTAID =
dbdSTATUS.staID FULL OUTER Join "&_
"dbdEVENTPOINTS ON dbdSCHEDULE.schETYPE
= dbdEVENTPOINTS.evpID FULL OUTER Join "&_
"dbdEVENTTYPE ON dbdSCHEDULE.schOTYPE =
dbdEVENTTYPE.evtID FULL OUTER Join "&_
"dbdCOUNTRY ON dbdSCHEDULE.schCOU =
dbdCOUNTRY.couID FULL OUTER Join "&_
"dbdSEASON ON dbdSCHEDULE.schSEA =
dbdSEASON.seaID FULL OUTER Join "&_
"dbdMON ON dbdSCHEDULE.schMON =
dbdMON.monID FULL OUTER Join "&_
"dbdTA2 ON dbdSCHEDULE.schTA2 =
dbdTA2.ta2ID FULL OUTER Join "&_
"dbdTA1 ON dbdSCHEDULE.schTA1 =
dbdTA1.ta1ID "&_
"WHERE dbdSCHEDULE.schMAIL = 0"
SET RS = oConn.Execute(strSQL) <----
FM:
Falsche Syntax in der N�he von "," (???)
Wer kann mir blutigen VBS Anf�nger helfen??
Danke und Gr��e,
Alexander
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Kaffeepause im United Planet Communityserver ...
http://www.intrexx.com/communityserver
_______________________________________________
Coffeehouse mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/coffeehouse
