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

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

Correct, the "_" character is a line continuation marker, so the last continued line would not need one.

Regards,

Ax

Hi Ax238,

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

regards
Parms.