I had a similar error last week. When using date comparison with QoQ with MX, you need to use <cfqueryparam value="#someDate#" cfsqltype="CF_SQL_DATE">.
Benoit Hediard www.benorama.com > -----Message d'origine----- > De : Buddy [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 18 juin 2003 02:08 > À : CF-Talk > Objet : CF MX Q of Q error.... > > > I just upgraded a box to cfmx and now I am debugging the code. > I am getting this error on code that worked well in cf5: > > Error Executing Database Query. > > Query Of Queries runtime error. > Unsupported type comparison. > > 227 : <cfquery name="SelectASites1" dbtype="QUERY"> > 228 : Select RAW as TRaw from SelectWMDATA WHERE TDATE> > '#DateFormat(LOOPSTARTDATE,"yyyy/mm/dd")# 00:00:00' and TDATE< > '#DateFormat(LOOPENDDATE,"yyyy/mm/dd")# 23:59:59' > 229 : </cfquery> > > > The field RAW that is being selected is a DATETIME field from a > SQL SERVER. > > Any insight into why I am having a problem? > Do I need to cast my date as something else even though I am doing a date > format? > > I'm so confused..... thanks for any help in advance. > -Buddy > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
