This is a known issue when using SELECT *. Somewhere along
the way the CF
or the JDBC driver is caching the column list it expects to
get back from
the DB, and it gets confused when the DB returns a different
column list,
despite the fact the SQL statement is the same.
The solution is to not use SELECT *, which is generally
considered poor
practice anyhow.
Do you actually mean to get ALL the columns back for that
table, or are you
using SELECT * as a short cut to not have to think about
which columns you
might want? It's usually the latter.
You should also put the two dates into <cfqueryparam>
tags too. And
possibly use the BETWEEN operator, rather than the >=
& <= ones.
--
Adam