Select * from table t where t.language = 'english' On Sat, Oct 30, 2010 at 10:55 PM, fun and learning <[email protected]> wrote: > > 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:338702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
