> For the following SQL there is no error, I just don't get any records ...
Verify there are actual records present. Easiest way is to change
your inner join to a full outer join and see what happens.
> NOT TRUE, and maybe significant -- I only get the first record in the
> classes table on days when that entry exists. !?! (I'm doing an <cfoutput
> query=queryname> so I'm really confused.)
Use cfdump.
> SELECT classes.*, classDates.*
> FROM classes INNER JOIN classDates ON classes.classID = ""> > WHERE classDate=#createodbcdatetime(eventDay)#
Use cfqueryparam.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
