Does the database understand the date? With Oracle we have to use to_char or to_date (I forget at the moment).
Chris Norloff ---------- Original Message ---------------------------------- From: Dave Watts <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Sun, 2 Feb 2003 14:31:28 -0500 >> Anyone want to take a shot at why this query throws a >> PCCode error every once in a while? CF5... >> >> <cftry> >> <cfquery name="qry_prod" datasource="#variables.dsn#" >> cachedafter="01/01/01"> >> select *, lower(keywords) as l_keywords >> from v_products >> where WebStoreID = #request.webStoreID# >> </cfquery> > >Maybe it has to do with the caching? I've occasionally seen some weird >errors relating to query caching. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
