Access With Unicode

I get an:

Error Executing Database Query

Message

It uses the OLEDB driver rather than ODBC, so you might have to change
some syntax. However, the end result is much better as the ODBC-JDBC
bridge can't handle more than a few users. Post the code if you have any
more problems
HTH

--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

It doesn't seem to like my where clause

<cfquery name='get_headlines' datasource='myDsn'>
SELECT * FROM content
WHERE section = news
ORDER BY date_modified desc
</cfquery>

if there are a lot of differences does anyone know a website that can give me more info

Please can someone tell me how you write queries that work with Acess with
unicode for example how would this be written: <cfquery name='get_headlines'
datasource='myDSN'> SELECT * FROM content WHERE section = 'news' ORDER BY
date_modified desc </cfquery> Any websites that give more info woul be much
appreciated. Thanks!

northernmonkey wrote:

> Please can someone tell me how you write queries that work with Acess with
> unicode for example how would this be written: <cfquery name='get_headlines'
> datasource='myDSN'> SELECT * FROM content WHERE section = 'news' ORDER BY
> date_modified desc </cfquery>

What you might want to try is replacing the * with the list of
fields you are interested in. That occasionally gives problems
which appear to be related to some security setting in the Access
database, but I don't know which one. (I try to avoid Access.)

Jochem

--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion, beer and fun.

It *might* be the word "section" as it's listed as a reserved word in M$
Access. http://support.microsoft.com/default...;EN-US;q209187
You can get around reserved words by 1) not using them and 2) escaping
them with brackets e.g. [section] = 'news'
Also, are you searching within "section" for 'news'? If so use single
quotes around your search term 'news'

HTH

--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

really apprecite the help if you where hear i would probably kiss you ..................................... maybe not!