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
                                

Reply via email to