Isn't language a reserved word? I'm not sure. Try <cfquery name="getGreek" datasource="languageTestx"> SELECT content FROM [language] </cfquery>
Allan ----- Original Message ----- From: "Richard Cooper" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, June 18, 2005 10:49 PM Subject: SPAM-LOW: Re: Access + unicode > >Richard Cooper wrote: > >> Error Executing Database Query. > > > >that's all there was? nothing else? > >>>Nope. That was it even with buggin enabled. > > > >> It's a bog standard cfquery but its not working: > >> <cfquery name="getGreek" datasource="languageTestx"> > >> SELECT content > >> FROM language > >> </cfquery> > > > >http://support.microsoft.com/kb/q209187/ nothing in there about either > >content or language. > > > >> I'm guessing there must be a setting somewhere in CF admin or something? > > > >no but what driver? the access for unicode one? > >>> Yes. If I connect to the DB using the normal one I can but the characters come out as question marks etc. WHen I try to connect to the data source using "Access with unicode support" I get the error message. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
