Re: Different result from same SQL statement

[Ian Skinner <iskinner@xxxxxxxxxxx>]

Anthony Spears wrote:
> That didn't work either.  
>
>  But here is something interesting.  If we use the dates 05/01/2007 and 
> 06/01/2007 we get results in SQL Server Query Analyzer but not using a cold 
> fusion page.  But if we use the dates 05/01/2007 and 09/01/2007 both get back 
> the same results.

Are you absolutely, 100% sure that you are connecting to the same 
database instance with both CF and Query Analyzer?  That kind of symptom 
is 9 out of 10 times because the user is looking at different data.  One 
is looking at production and the other development or an backup or 
recent copy or something different.