Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: Error when submitting to SP from ASP page.

    Hi all.

    ======= ERROR MESSAGE ==================
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'Entry Level 1'.

    /learningcentres/questionnaire/updatequestionnaire.asp, line 279
    =======END MESSAGE =====================

    I get the error message above when submitting to a stored procedure, from an asp page.

    Its a simple update which submits to a stored procedure, but I seem to be getting the error before hitting the SP.

    The error occurs whether there is contents on the submitting page or not, I am also not sure if it is relating to the contents of the field directly before the one which contains the ("Entry Level 1") text, which is a combo box, or another field before it.

    I have checked the contents of the form and even if I leave it blank, as a test, I still get the same error message.

    Does the error message relate to contents, or is it a coding issue?

    Any help would be appreciated.

    Gazzer

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Sounds like coding.. post the relevant ASP code, and the SP if possible...
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Dec 2003
    Posts
    454
    Please post the ASP code to call the SP.

Posting Permissions

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