On Saturday 07 October 2006 17:55, Christopher Lavie wrote:
Have you tried dateCompare() instead of <= ? Also, mySql takes a little different format with the storage of date/time values. It displays DATETIME values in 'YYYY-MM-DD HH:MM:SS > This probably has a simple, obvious solution, > but it's frustrating the > hell out of me. > > I am using ColdFusion MX 7 and a MySQL > database. I have a database of > surveys taken with each record having a date that the survey was taken. > > I am trying to pull records between two dates. > > This code worked just fine with an Access > database but not with the > MySQL database: > > <cfset Session.WhereClause = > Session.WhereClause & " AND > ((Survey.ShopDate BETWEEN ## #NewBeginDate# ## AND ## #NewEndDate# ##))"> > > (Later, I apply the Session.WhereClause > variable to the SQL statement.) > > The following code works just fine when I use > it in the database itself > (obviously replacing the variables with actual dates). Unfortunately it > returns no records in my ColdFusion code when I leave off the single > quotes, and it returns a syntax error when I include the quotes. > > <cfset Session.WhereClause = > Session.WhereClause & " AND > Survey.ShopDate >= '#NewBeginDate#' AND Survey.ShopDate <= '#NewEndDate#' > "> > > I have tried the CreateODBCDateTime function to > no avail. > > Can anybody help me? I'm at my wits end. > > Thanks! > > Chris > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
