MS Access with Unicode driver problems

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default MS Access with Unicode driver problems

    When using the Microsoft Access driver, the below works.

    When using the Microsoft Access with Unicode driver, I get a message stating
    #clinicid#" not defined.

    Why the difference?

    <CFQUERY DATASOURCE="somesource" NAME="list">
    SELECT * FROM classlist order by clinictitle, date1
    </CFQUERY>
    ...
    <CFOUTPUT QUERY="list">
    <TR>
    <TD><a href="somepage.cfm?clinicid=#clinicid#">#clinictit le#</a></TD>
    </TR>
    </CFOUTPUT>

    Thank you for any information.

    Brian A


    brianHF Guest

  2. Similar Questions and Discussions

    1. #18169 [Com]: Driver cannot deliver UCS-2 unicode to SQL Server
      ID: 18169 Comment by: aireater at gmail dot com Reported By: joesterg at hotmail dot com Status: No Feedback...
    2. MS Access unicode compression
      Using both CF 5 and 6 with MS Access 2002 as the database. Trying to create and maintain tables through a ColdFusion app, and running into...
    3. Access + Unicode
      Hi, I require the use of an Access 2000 DB with windows 2000 and CF MX 6. I would like to be able to provide information in multiple languages...
    4. Access With Unicode
      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...
    5. Coldfusion MX 7.0 with 'Access with Unicode'
      I used to use Coldfusion 5 with Access DB (Using ODBC DSN) under IIS, everything works fine. Now I upgraded Coldfusion 5 to Coldfusion MX 7.0 with...
  3. #2

    Default Re: MS Access with Unicode driver problems

    I changed to using the jdbc driver and it is working fine now.
    brianHF Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139