I second this. Use [language] as it's probably reserved.
On Sun, Oct 31, 2010 at 2:24 AM, Leigh <[email protected]> wrote: > > >> Query is something like > > What is the _exact_ query and error message? > > > When I remove the language criteria, its working fine. > > A complete guess but ... could "language" be a reserved word with your > driver? Any change if you escape the column name with square brackets ? > > ie > WHERE [language] = 'some value' > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
