Nope, this should run on an Access datasource, at worse you may need to remove the <CFQUERYPARAM>s but the rest should be fine...
HTH -----Original Message----- From: Jake . [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 20:20 To: CF-Talk Subject: Problems with date based query This would be SQL Server specific though, right? Unfortunately, this app is using Access. >You could try something like.... > > ><CFQUERY name="findRecent" datasource="Categories"> > SELECT * > FROM Links > WHERE DateAdded BETWEEN <CFQUERYPARAM >VALUE="#CreateODBCDateTime(DateAdd('d', -3, Now()))#" >SQLTYPE="CF_SQL_TIMESTAMP"> AND <CFQUERYPARAM VALUE="#Now()#" >SQLTYPE="CF_SQL_TIMESTAMP"> > AND approve=1 > ORDER BY DateAdded DESC ></cfquery> > > >Or something like that ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
