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/unsubscribe.cfm?user=89.70.4
