And dumb question here, but finnished? Isn't it finished (with only one "n")? Maybe it's spelled correctly in the database and not in your code?
=) Finnished... Is that a way of being made a person from Finland? Some kind of metamorphosis or something? -----Original Message----- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:02 AM To: CF-Talk Subject: Re: Problems with a query going from CF 5 to CFMX 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4