Syntax error while calling sql query in JS

Question

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 ="")"

GMB · Accepted Answer · 2020-09-02 20:11:42Z

2

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 = '')"

answered Sep 2, 2020 at 20:11

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shubham Dixit · Accepted Answer · 2020-09-02 20:10:30Z

1

Make it something like below ,use single quotes for values

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

answered Sep 2, 2020 at 20:10

Shubham Dixit

9,2685 gold badges32 silver badges50 bronze badges

Collectives™ on Stack Overflow

Syntax error while calling sql query in JS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related