VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work
I'm using Visual Basic with DAO 3.6 and I try to execute this query dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.geb='1978-08-26') Here I get an Error-Message: Runtime-Error 3464, ... If I use any other SQL-Query-Tool (e.g. MySQLFront) this query works and returns (as estimated) 1 Record. Any other query which is not using any date works, e.g.: dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.VName='Florian') I hope you could help me solving this problem. By the way: Sorry for my bad english! Thanks Florian Lagg ([EMAIL PROTECTED]) __ Ferienklick.de - Jede Menge Urlaub auf einen Blick! Hier geht's zu Ihrem Traumstrand: http://ferienklick.de/?PP=2-0-100-105-1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work
I'm using Visual Basic with DAO 3.6 and I try to execute this query dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.geb='1978-08-26') Here I get an Error-Message: Runtime-Error 3464, ... If I use any other SQL-Query-Tool (e.g. MySQLFront) this query works and returns (as estimated) 1 Record. Any other query which is not using any date works, e.g.: dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.VName='Florian') I hope you could help me solving this problem. By the way: Sorry for my bad english! Thanks Florian Lagg ([EMAIL PROTECTED]) __ Sie surfen im Internet statt im Meer? Selbst schuld! Auf zum Strand: http://lastminute.de/?PP=1-0-100-105-1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php