> Troubleshooting
>
> 1. see if simple queries (one table) work -- they do
> 2. take out the WHERE clause to make certain the join works -- it does
>
> The error is with the date as the WHERE clause works with other fields
>
> Can there be a date v date/time issue?
Yes.
> If so how to determine it?
Use cfqueryparam with the right cfsqltype and pass in the date in
"yyyy-mm-dd" format (or if the datatype is actually a timestamp,
use "yyyy-mm-dd hh:mm:ss").
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
