Re: [PHP-DB] receiving date elements from Access

[Jan Bro]

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 [EMAIL PROTECTED] 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. (German
way)

Maybe you should try the date in the syntax the database uses, i.e.,
12.12.2002?

Sincerely,

Paul Burney







-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] receiving date elements from Access

[Paul Burney]

on 3/9/03 4:42 PM, Jan Bro at [EMAIL PROTECTED] 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. (German way)

Maybe you should try the date in the syntax the database uses, i.e.,
12.12.2002?

Sincerely,

Paul Burney






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] receiving date elements from Access

[Jan Bro]

Hi,
i've posted this in the general list, but I've got no answer. Well I'm still
hoping there is one ;-)

I've got the following code:

$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 error def. lays in Datumsfeld >'#$datum_beginn#'. How do I get a list of
all entries with a
date that lay behind a certain date? I'd prefer to let the database do the
job for me, rather than
pulling everything out and get the relevant data with php.

The field Datumsfeld is a date field with the syntax DD.MM. (German way)

thx
Jan




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php