SQL Encoding: With ADO
Posted on 1998-11-04
I find that when I encode strings from a form with ' or `, I get errors when trying to pass this string to the ADO object for inserting into a database table; its because it think the ' or ` character is the string terminator. This means any other fields are out of sync.
- name, message, ID, date
"joe", "it's friday", 256, #12-3-1998#
this is encoded as
"joe", "it`'`s friday", 256, #12-3-1998#
This still produces an error from ADO!