(0x80040E14) Syntax error (missing operator) in query expression single quotes

**devine** · 07-03-2006, 06:00 AM

Hi All,

I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example:
I'm going to....
It's happening......
It'll take place......
The Conn.Execute(strSQL) statement then fails as it appears that it can process the date before the quote marks (i.e. It), but can't process the data following the quote marks (i.e ll take place)
Is there a simple solution to this problem?
Thanks!

**chrishirst** · 07-03-2006, 06:29 AM

escape the single quotes with a single quote as a replace function.

stripQuotes()

**bkrajendra** · 04-01-2008, 05:23 AM

Hi you can use replace function in vb
if u r using ASP
strIn=Replace (strIn, "'", "''")

07-03-2006, 06:29 AM	#2 (permalink) Re: (0x80040E14) Syntax error (missing operator) in query expression single quotes
chrishirst Super Moderator Posts: 10,642 Location: Blackpool. UK Talkupation:	escape the single quotes with a single quote as a replace function. stripQuotes() __________________ Chris. ->> Links are advertising NOT optimising!! <<- Indifference will be the downfall of mankind, but who cares? Code Samples \| People Counting System

07-03-2006, 06:00 AM	#1 (permalink) (0x80040E14) Syntax error (missing operator) in query expression single quotes
devine Average Talker Posts: 25 Talkupation:	Hi All, I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example: I'm going to.... It's happening...... It'll take place...... The Conn.Execute(strSQL) statement then fails as it appears that it can process the date before the quote marks (i.e. It), but can't process the data following the quote marks (i.e ll take place) Is there a simple solution to this problem? Thanks!

04-01-2008, 05:23 AM	#3 (permalink) Re: (0x80040E14) Syntax error (missing operator) in query expression single quotes
bkrajendra Junior Talker Posts: 1 Name: Rajendra Khope Location: Pune Talkupation:	Hi you can use replace function in vb if u r using ASP strIn=Replace (strIn, "'", "''")