keyboard, namely me.
I er, um, ahh put in some test data in the classDates table and BECAUSE it
was test data I set the classID to non-existent numbers.
Funny how getting some sleep helps. I saw it the moment I came back.
Thanks everybody for the help.
gil midonnet
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:46 PM
To: CF-Talk
Subject: Re: trouble shooting advice WAS: SQL join not working
mayo wrote:
> 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]
