Professional Web Applications Themes

Access: (missing operator) in query expression - ASP Database

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 ...

  1. #1

    Default 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

  2. #2

    Default 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

Similar Threads

  1. Syntax error (missing operator) in query expression
    By crystalfish0318 in forum Coldfusion Database Access
    Replies: 3
    Last Post: May 23rd, 06:00 PM
  2. Replies: 6
    Last Post: September 2nd, 01:22 PM
  3. Replies: 4
    Last Post: September 29th, 10:23 AM
  4. Missing Operator Error in Access
    By CJM in forum ASP Database
    Replies: 2
    Last Post: July 14th, 08:23 AM
  5. Replies: 4
    Last Post: July 11th, 07:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139