Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135

    Unanswered: VBScript runtime (0x800A000D) error

    Hi all, Hope someone can help / point me in the right direction with this problem.

    I have a "save" button that is suppose to write to a database, but when i click on the button i get this error message:

    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: '[string: ","]'
    /admin/stores/index.asp, line 380

    here is the code at line 380:

    Sub UpdateStoreDetailsRow()
    sSQL = "EXEC spUpdateStoreDetails " & iStoreID & ",'" & sOpensMonday & "'" &_ (line 380)
    ",'" & sClosesMonday & "'" &_
    ",'" & sOpensTuesday & "'" &_
    ",'" & sClosesTuesday & "'" &_
    ",'" & sOpensWednesday & "'" &_
    ",'" & sClosesWednesday & "'" &_
    ",'" & sOpensThursday & "'" &_
    ",'" & sClosesThursday & "'" &_
    ",'" & sOpensFriday & "'" &_
    ",'" & sClosesFriday & "'" &_
    ",'" & sOpensSaturday & "'" &_
    ",'" & sClosesSaturday & "'" &_
    ",'" & sOpensSunday & "'" &_
    ",'" & sClosesSunday & "'" &_
    ",'" & sTelNumber & "'" &_
    ",'" & sFaxNumber & "'" &_
    ",'" & sEmailAddress & "'" &_
    ",'" & sSocialProfileAddress & "'" &_
    ",'" & sPostalAddress & "'" &_
    "," & iWinID & "'"&_

    oDB.execute(sSQL)
    End Sub

    Any help with this would be great.


    Kind regards
    MG

  2. #2
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135
    Hi all,

    Just to let you know i removed & ""&_ (from the last line) and it seems to work although, im not entirely sure for the reason behind it, so if someone could explain that would be great.

    I think it may be because the line of code is trying to find the next bit of the code, but its not there? (poor terminology i know, lol)

    Regards
    MG
    Last edited by mind_grapes; 07-02-09 at 13:09.

  3. #3
    Join Date
    May 2009
    Posts
    258
    Correct, the "_" character is a line continuation marker, so the last continued line would not need one.

    Regards,

    Ax

  4. #4
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135
    Hi Ax238,

    thanks for the confirmation, will be logged for future ref.

    regards
    Parms.

Posting Permissions

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