Hello all.
I have a piece of code that looks like this:
<cfscript>
finnishedWorkflow = duplicate(session.workflow.process);
</cfscript>
<cfquery dbtype="query" name="getMaxActivePage">
SELECT *
FROM finnishedWorkflow
WHERE Bit = 1
ORDER BY Priority
</cfquery>
It is working fine in CF 5. I moved it over to CFMX and it is not working. I am
getting the error:
Query Of Queries syntax error.
Encountered "Bit" at line 4, column 19. Incorrect conditional expression, Expected one
of [like|null|between|in|comparison] condition
Can anyone shed some light as to what may be causing this?
Thanks,
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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