Use <CFQUERYPARAM>.
  ----- Original Message -----
  From: Justin Jefferson
  To: CF-Talk
  Sent: Thursday, October 23, 2003 4:11 PM
  Subject: [cftalk] CF5 Special Characters issue

  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.

  Thanks  

  How do I tackle this issue?

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to