I am tryting to enter in values into the database that contain "'" for example the name: Paul O'Keefe gives me an error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression
''HEATH JK, Southby J, Fukumoto S, O'Keeffe LM'.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying
document position (166:2) to (166:50).
How can I prevent Netscape to take the "'" as being the end of the string? I have tried URLEncodedFormat but it inserts %20 for spaces and other characters.
Thanx for any help [sig][/sig]
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression
''HEATH JK, Southby J, Fukumoto S, O'Keeffe LM'.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying
document position (166:2) to (166:50).
How can I prevent Netscape to take the "'" as being the end of the string? I have tried URLEncodedFormat but it inserts %20 for spaces and other characters.
Thanx for any help [sig][/sig]
