is the name of the table 'table'? If so then try changing it!
Regards, Arsalan -------------------------------------------------- From: "fun and learning" <funandlrnn...@gmail.com> Sent: Sunday, October 31, 2010 10:55 AM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: MS Access Coldfusion > > 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:338704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
