Hello Everyone! I have a rather basic question. I have a simple username and password front end that queries a SQL database, I run into problems when one of the user names has a single quote in it (IE: O'brian). I get the "Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near 'brian'." error message, any clues on how to display those particular cases? is there anything in particular that should be done to my SQL statement? Thank you very much for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Querying single quote strings in website front end
- Thread starter garp2100
- Start date
DotNetGnat
Programmer
use...replace() function
Replace(myvariale, "'","''")
-DNG
Replace(myvariale, "'","''")
-DNG
- Status
Similar threads
- Locked
- Question
- Locked
- Question