> When a user enters a special character like 'é' from "'Asistente de
> Programas para Aprendices de Inglés", is giving a error of
>
> "Error","31","10/20/03","17:46:17",,"ODBC Error Code = 37000 (Syntax
> error or access violation)<P> [MERANT][ODBC SQL Server Driver][SQL
> Server]Unclosed quotation mark before the character string
> 'Asistente de Programas para Aprendices de Ingl'
>
> I tried the PreserveSingleQuotes function in the SQL insert
> statement, but that did not work.
>
> If anyone can help, that would be great.
1. Short term workaround (today): cfqueryparam
2. Long term solution (tomorrow): CF MX & unicode
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
