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
