Oooops!! the title of my last post was stricken by some random dyslexia. :) should read works on CF 5 bombs on MX
> I've got this query of query that's working on CF 5... On > MX it produces > this error: > Error Executing Database Query.<br><b>Query Of Queries > syntax error.</b><br> > Encountered ""from"" at line 5, column 44. Incorrect > conditional expression, > Expected one of [like|null|between|in|comparison] > condition, The specific > sequence of files included or processed is: > C:\CFusionMX\wwwroot\dev\talkontap\index.cfm > <cfquery name="rsnew" dbtype="query"> > SELECT nick, message FROM history > WHERE msgid > #attributes.cleared# AND > ( nick = '' OR nick = '#trim(ucase(attributes.nick))#' > OR from = '#trim(ucase(attributes.nick))#' ) > </cfquery> > The "specific sequence of files included or processed" is > incorrect, but > from the error message saying "Encountered ""from"" at > line 5" it seems like > it's complaining about my having a from clause after the > select list, which, > last I checked is where a from clause belongs. > This query is generated manually using querynew(), > queryaddrow() and > querysetcell() functions. > Any suggestions or advice greatly appreciated. I'm stumped > at the moment. :) > s. isaac dealey 954-776-0046 > new epoch http://www.turnkey.to > lead architect, tapestry cms http://products.turnkey.to > tapestry api is opensource http://www.turnkey.to/tapi > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > 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 > Get the mailserver that powers this list at > http://www.coolfusion.com > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
