Special characters

[Excel User]

Hi,

I have a field that contains special characters (', % etc) the ' causes
problems because it messes up the SQL insert/update command, what is the
best way to deal with this, I tried encode but then the entry in the DB is
not correct?

Thanks for any advice.

 

[Bob Barrows]

Hi,

I have a field that contains special characters (', % etc) the '
causes problems because it messes up the SQL insert/update command,
what is the best way to deal with this, I tried encode but then the
entry in the DB is not correct?

Thanks for any advice.

Use parameters. See:
http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e

Personally, I prefer using stored procedures, or saved parameter queries
as they are known in Access:

Access:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]

http://groups.google.com/groups?hl=...=1&[email protected]

SQL Server:
http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/5d3c9d4409dc1701?hl=en

 

[Sylvain Lafontaine]

You double them.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)