On Thursday, Jun 19, 2003, at 07:08 US/Pacific, Jochem van Dieten wrote:
> Bruce Sorge wrote:
>>
>> <cfscript>
>> finnishedWorkflow = duplicate(session.workflow.process);
>> </cfscript>
>> <cfquery dbtype="query" name="getMaxActivePage">
>> SELECT *
>> FROM finnishedWorkflow
>> WHERE Bit = 1
>> ORDER BY Priority
>> </cfquery>
>
> Isn't bit a reserved word?
Yes. Try this instead:
<cfquery dbtype="query" name="getMaxActivePage">
SELECT *
FROM finnishedWorkflow
WHERE [Bit] = 1
ORDER BY Priority
</cfquery>
i.e., use [ ] to 'escape' the keyword so it can be used as a column
name.
Sean A Corfield -- http://www.corfield.org/blog/
"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
