Access With Unicode

Posted: 02-16-2005, 04:28 PM
For some reason ODBC for coldfusion isn't working so I have to use the unicode driver. None of my quieries are working do I have to write them differently when using Access with Unicode?

Thanks
Reply With Quote

Responses to "Access With Unicode"

PaulH
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 05:11 PM
access for unicode is probably a better choice. what exactly isn't working?
Reply With Quote
northernmonkey
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 06:39 PM
I get an:

Error Executing Database Query

Message

Reply With Quote
Mountain Lover
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 07:01 PM
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
Reply With Quote
northernmonkey
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 07:44 PM
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>
Reply With Quote
northernmonkey
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 07:46 PM
if there are a lot of differences does anyone know a website that can give me more info
Reply With Quote
northernmonkey
Guest
Posts: n/a
 
Access With Unicode
Posted: 02-16-2005, 08:35 PM
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!

Reply With Quote
Jochem van Dieten - TMM
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 08:44 PM
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.
Reply With Quote
Mountain Lover
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 08:55 PM
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
Reply With Quote
northernmonkey
Guest
Posts: n/a
 
Re: Access With Unicode
Posted: 02-16-2005, 09:07 PM
really apprecite the help if you where hear i would probably kiss you ..................................... maybe not!
Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Unicode connection crashes whith password mpvinci Coldfusion Database Access 2 10-20-2005 01:07 AM