thanks Owen.. will give it a spin... one of the few times I got stumped with cryptic error in CF...
-----Original Message----- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 22:09 To: CF-Talk Subject: RE: CFDIRECTORY and QUERY OF QUERY > SQL = "select * from photos where datelastmodified between {d > '2002-03-12'} > and {d '2002-03-19'}" I ran into the same problem with a similar query, and this was the solution for me: SELECT * FROM cfdirectory_results WHERE datelastmodified < '#DateFormat(Now(), 'mm/dd/yyyy')#' It just needed the DateFormat() function. -- Owen ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
