Skip to content
Advertisement

Syntax error while calling sql query in JS

I am trying to call this query from JS but I got syntax error. Here I am checking if value is equal to "" or no but when I write this query inside " " in Js I got an error. How can I write this in Js differently.

"select * from Slot where Slot.TeacherID="T2" and (Slot.ReservedStudent IS NULL OR Slot.ReservedStudent ="")"

Advertisement

Answer

The inner double quotes are clashing with the outer quotes. That’s a syntax error in Javascript to begin with, before the database is hit.

You would better use single quotes within the SQL text – that’s the standard character for literal strings anyway, while double quotes stand for identifiers such as column or table names (although some databases, such as MySQL, support double quotes for strings):

sql = "select * from Slot where Slot.TeacherID='T2' and (Slot.ReservedStudent IS NULL OR Slot.ReservedStudent = '')"

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement