macromedia.coldfusion.database_access
[Top] [All Lists]

Re: Different result from same SQL statement

Subject: Re: Different result from same SQL statement
From: Ian Skinner <iskinner@xxxxxxxxxxx>
Date: Wed, 23 Jan 2008 09:46:31 -0800
Newsgroups: macromedia.coldfusion.database_access


Ian Skinner wrote:
.... BETWEEN <cfqueryparam value="05/01/07" cfsqltype="cf_sql_date"> AND ...

OR maybe that should be:

... BETWEEN <cfqueryparam value="#createODBCDate('05/01/07')#" cfsqltype="cf_sql_date"> ...



<Prev in Thread] Current Thread [Next in Thread>