[PHP-DB] receiving date elements from Access

2003-03-09 Thread 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

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

2003-03-09 Thread 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
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

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

2003-03-09 Thread 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
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