Re: Different result from same SQL statement

[Jochem van Dieten **AdobeCommunityExpert** <nomail@xxxxxxxxxxxxxxx>]

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.

In that case the first thing to do is to disambiguate your dates. Use 
the format yyyy-mm-dd so you are certain the dates will be interpreted 
the same on both sides regardless of locale.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion