� anstatt " ? Meik Schuetz DID - Departmento Desenvolvimento e Investiga��o PRIMAVERA Software, S. A. Telefone: +351 (253) 309-900, Fax: +351 (253) 309-909 http://www.primaverasoftware.pt
-----Original Message----- From: Christoph Wille [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 31 de Mar�o de 2003 14:52 To: [EMAIL PROTECTED] Subject: Re: [Database.asp] Was mag ADO da nicht Es wird immer mysteri�ser... klarerweise habe ich die Brutalovariante Plain-SQL ausgepackt: SELECT UserFullname,UserEmail,AssignedLanguages from Users WHERE AccountDisabled=False AND (Users.AssignedLanguages = "de" OR Users.AssignedLanguages LIKE "%,de" OR Users.AssignedLanguages LIKE "%,de,%" OR Users.AssignedLanguages LIKE "de,%") Jetzt sagt er mir vier Parameter fehlen (wieder die AssignedLanguages-welche). Access mag diese Abfrage sehr wohl (mit Sternchen statt %). Ideen? Chris At 03:40 PM 3/31/2003 +0200, you wrote: >Setze folgende Abfrage gegen eine Accessdatenbank ab: > >SELECT UserFullname,UserEmail,AssignedLanguages from Users WHERE >AccountDisabled=False AND (0 <> InStr([AssignedLanguages],"de")) > >Funktioniert toll in MS Access, allerdings meckert mir ADO in einer ASP >Seite das so an (in einem rs.Open): > >Microsoft OLE DB Provider for ODBC Drivers error '80040e10' >[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. >/OpenSource/SD/Translation/inc_paging_extended.asp, line 56 > >Wie bringe ich ADO zur Kooperation? ([] auslassen hilft nix) ~~~~~~~~~~~~~~~~~~~~~~~~~~~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
