Hallo Babsi,
ich gehe davon aus, dass ID ein Autowert bzw. Zahlenwert ist - dann kommen
die " überall weg.
Des weiteren hast Du ein Ausrufezeichen in der Liste ;)
Gruss
Jutta
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 11:03 AM
Subject: [Database.asp] Probleme mit folgender Query
>
> select b.emailaddress, a.companykey, a.customerid, b.lastname from
ispcustomer a
> inner join ispcontact b on a.billingcontactkey = b.contactkey
> where a.status = 'N' or a.status = 'A' and a.customerid is not in {"50045"
,"50142" ,"50188" ,"50233" ,"50280" ,"50325" ,"50372" ,"50415" ,"50460"
,"50506" ,"50552" ,"50599" ,"50646" ,"50743" ,"50796" ,"50846" ,"50893"
,"50948" ,"0033951" ,"0005308" ,"50002" ,"50005" ,"50007" ,"50008" ,"50009"
,"50010" ,"50013" ,"50015" ,"50016" ,"50017" ,"50018" ,"50019" ,"50020"
,"50021" ,"50022" ,"50023" ,"50025" ,"50026" ,"50028" ,"50029" ,"50030"
,"50032" ,"50033" ,"50034" ,"50035" ,"50036" ,"50037" ,"50038" ,"50039"
,"50040" ,"50041" ,"50042" ,"50044" ,"0005310" ,"40002" ,"40003" ,"40004"
,"40005" ,"40008" ,"40012" ,"40011" ,"40014" ,"40015" ,"40016" ,"40017"
,"40018" ,"40019" ,"40020" ,"40021" ,"40023" ,"40024" ,"40026" ,"40028"
,"40029" ,"40030" ,"40031" ,"40032" ,"40033" ,"40035" ,"40036" ,"40037"
,"40038" ,"40039" ,"40040" ,"40041" ,"40042" ,"40044" ,"40046" ,"40047"
,"40048" ,"40049" ,"50553" ,"50555" ,"50556" ,"50557" ,"50558" ,"50559"
,"50560" ,"50561" ,"50562" ,"50564" ,"50567"!
> ,"50568" ,"50569" ,"50570" ,"50573" ,"50574" ,"50575" ,"50576" ,"50577"
,"50578" ,"50579" ,"50580" ,"50581" ,"50582" ,"50583" ,"50584" ,"50585"
,"50586" ,"50587" ,"50588" ,"50590" ,"50592" ,"50593" ,"50595" ,"50596"
,"50598" ,"50600" ,"50601" ,"50602" ,"50603" ,"50604" ,"50605" ,"50607"
,"50608" ,"50612" ,"50613" ,"50615" ,"50616" ,"50617" ,"50618" ,"50620"
,"50621" ,"50622" ,"50623" ,"50625" ,"50626" ,"50627" ,"50629" ,"50633"}
>
> Ich bekomme folgenden Fehler:
>
> [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
>
>
> Was mache ich falsche?
>
> Danke
> Babsi
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
> Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
> ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com
> _______________________________________________
> Database.asp mailing list
> [EMAIL PROTECTED]
> http://www.glengamoi.com/mailman/listinfo/database.asp
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp
