oh, i've forgot to mention, I've already tried that, with the same result, sorry my mistake. Even 12.12.2002 brings back the same result. It doesn't make a difference if I use # or not. But thx anayway, i'm sure it is some dumb mistake i made. Jan on 3/9/03 4:42 PM, Jan Bro at janbro@web.de appended the following bits to my mbox: > $datum_beginn="2002-12-12"; > $datensatz=odbc_exec($db_connection,"select * from Termin where Datumsfeld>'#$datum_beginn#'"); > > I get an error message that data in criteria doesn't match. (free > translation) > The field Datumsfeld is a date field with the syntax DD.MM.YYYY (German way) Maybe you should try the date in the syntax the database uses, i.e., 12.12.2002? Sincerely, Paul Burney <http://paulburney.com/> <?php while ($self != "asleep") { $sheep_count++; } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
