Ask a Question related to ASP Database, Design and Development.
-
Bob the ASP Builder #1
Access: (missing operator) in query expression
Hi!
I operate a database where visitors do inputs directly from the web thru
a form. One field has the datatype (property?) Memo and I have not set
any limits to it.
When visitors make entries containing quotation marks ( " or ' ) the
entry fails and returns this message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression
I want the visitor to be able to use quotation marks - how can I solve
this neatly??
Bob the ASP Builder
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!
Bob the ASP Builder Guest
-
[microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when... -
Syntax error (missing operator) in query expression
Hi, I have received the following error: ODBC Error Code = 37000 (Syntax error or access violation) Syntax error (missing operator) in query... -
Syntax error (missing operator) in query expression'idProperty='
The following is the code, can someone please help me with the syntax please in the first line please Conn.Execute "UPDATE tblRentalProperty SET... -
Missing Operator Error in Access
I'm trying to install a freebie app downloaded from the web. Its based on an Access Db, and I'm getting the a missing operator error for the... -
syntax error (missing operator) query expression
valuA = (request.form("toadd")) If valuA = "" then SQL = "UPDATE CourseReg SET attended='Active' WHERE ID IN("&request.form("toadd")&")" Set RS =... -
Atrax #2 Re: Access: (missing operator) in query expression
[url]http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=21[/url]
________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]
newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!
Atrax Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
