Re: Different result from same SQL statement

[Ian Skinner <iskinner@xxxxxxxxxxx>]

Anthony Spears wrote:
> I got back records when I took out the AND (h.lu_date BETWEEN '05/01/07' AND 
> '06/01/07').
>
> Does this give you any more clues??
>
> Thanks in advance.

What happens if you tell your systems those strings are dates?

... BETWEEN <cfqueryparam value="05/01/07" cfsqltype="cf_sql_date"> AND ...