Re: receiving date elements from Access
| From: | Jan Bro | Date: | Mon, 10 Mar 2003 06:00:34 +0000 |
| Subject: | Re: receiving date elements from Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26218@lists.php.net to get a copy of this message | ||
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++;
}
?>