Hi All - I am trying to make a query to work in Coldfusion. The query works in MS Access though.
I have a column called 'language' in the database table. When I try to refer the column in Coldfusion, I get an error like value '' is invalid. Query is something like select * from table where language = 'english'. When I remove the language criteria, its working fine. I am working in eclipse, and the word language is highlighted like other key words. Is there a way I can work around this problem? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

