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