error '80040e14'

Results 1 to 3 of 3

Thread: error '80040e14'

  1. #1
    Join Date
    Dec 1969

    Default error '80040e14'

    I am getting the above error, followed by this detail.<BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039;productID=&#039;. <BR>I read in the FAQ section about reserved names, and i solved this by removing the reserved words I had in my database. Please could someone help in solving my problem?<BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default Gonna need some help...

    Post the code. Can&#039;t really tell from that...response.write your sql statement out and post it

  3. #3
    Join Date
    Dec 1969

    Default I'm a mind reader..

    I bet that you are putting the the ProductID from a querystring value or form value.<BR><BR>Most likely that value isn&#039;t being populated correctly.<BR><BR>Do this:<BR><BR>Response.Write sqlstatement<BR>Response.Write "&#060;hr&#062;"<BR>Response.Write "productID = &#039;" & productID & "&#039;" &#060;!-- put whatever variable you are using to store the product ID.<BR><BR>I bet it&#039;s empty.<BR>-Doug

Posting Permissions

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