Re: [PHP-DB] Query Access DB by date

2001-01-12 Thread John

Oops. Seems to work when I put the pound sign in the front and back of the
date :-) Thanks.

John

> >When I try to query an Acess database for a particular date I get ODBC
> >errors indicating I'm screwing up the call. Can anyone give me an example
of
> >a select on a date field. Quotes make it think it is a string. No quotes
> >make it think it is a number. The pound sign just says it doesn't know
what
> >I'm asking for. I'm confused. Thanks.
>
> The pound sign is correct. If your query doesn't work with the pound
> sign, then the problem is elsewhere. Post an example of your code.
>
> Bob Hall
>
> Know thyself? Absurd direction!
> Bubbles bear no introspection. -Khushhal Khan Khatak
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Query Access DB by date

2001-01-11 Thread Bob Hall

>When I try to query an Acess database for a particular date I get ODBC
>errors indicating I'm screwing up the call. Can anyone give me an example of
>a select on a date field. Quotes make it think it is a string. No quotes
>make it think it is a number. The pound sign just says it doesn't know what
>I'm asking for. I'm confused. Thanks.

The pound sign is correct. If your query doesn't work with the pound 
sign, then the problem is elsewhere. Post an example of your code.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]