Unterminated String error

Results 1 to 2 of 2

Thread: Unterminated String error

  1. #1
    Join Date
    Dec 1969

    Default Unterminated String error

    strSQL = "SELECT tblUsers.StudentID, tblUsers.ClassID, Assignments.Question, <BR>Assignments.StudentAnwer, Assignments.A, Assignments.B, <BR>I get the error message unterminated string but I have actually closed the string as seen in the code below. Can you help please.<BR><BR>Assignments.C, Assignments.D,<BR>Assignments.E, Assignments.F, Assignments.G, Assignments.H, Assignments.Score <BR>FROM Classes,tblUsers,Assignments <BR>where <BR>(Classes INNER JOIN Assignments ON Classes.ClassID =" Assignments.ClassID) <BR>INNER JOIN tblUsers ON Classes.ClassID = tblUsers.ClassID

  2. #2
    Join Date
    Dec 1969

    Default No newline

    You cannot break a VBscript statement or string over several lines. You must use an underscore to indicate that it continues on the next line.<BR><BR>strSQL = "SELECT tblUsers.StudentID, tblUsers.ClassID," & _ <BR>"Assignments.Question, Assignments.StudentAnwer, " & _<BR>" Assignments.A, Assignments.B, " <BR>

Posting Permissions

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