Unexpected Identifier Javascript SQL

Question

I'm trying to build a string of an sql statement using vars in javascript.

I got this line code

     var sql = "'INSERT INTO UPLOADS (poleID, submitDate, poleDamaged, poleDown, wireDown, brokenFixture, brokenBulb, fullname, phonenumber, email, comments, address, city, state, zipcode, lat, lng) VALUES (" + poleID + "," + submitdate + "," + poleDamaged + "," + poleDown + "," + wireDown + "," + brokenFixture + "," + brokenBulb + "," + fullname + "," phonenumber + "," + email + "," + comments + "," + address + "," + city + "," state + "," + zipcode + "," + lat + "," + "," + lng + ")" + "'";

and my Google Chrome dev tools console is throwing this error and pointing to the line above

Uncaught SyntaxError: Unexpected identifier

Any reason it is throwing this error? All vars are valid.

@igor this is executing on their device to a sqlite database. No connection to anyone else except for themselves. — Andrew Pearson
– Andrew Pearson, Commented Jun 6, 2013 at 20:47

Givi · Accepted Answer · 2013-06-06 20:51:57Z

1

Try this. you missed + in two places and an extra comma...

 var sql = "'INSERT INTO UPLOADS (poleID, submitDate, poleDamaged, poleDown, wireDown, brokenFixture, brokenBulb, fullname, phonenumber, email, comments, address, city, state, zipcode, lat, lng) VALUES (" + poleID + "," + submitdate + "," + poleDamaged + "," + poleDown + "," + wireDown + "," + brokenFixture + "," + brokenBulb + "," + fullname + "," + phonenumber + "," + email + "," + comments + "," + address + "," + city + "," + state + "," + zipcode + "," + lat + "," + lng + ")" + "'";

edited Jun 6, 2013 at 20:51

answered Jun 6, 2013 at 20:45

Givi

1,7342 gold badges21 silver badges35 bronze badges

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

1 Comment

Andrew Pearson Over a year ago

You sir are correct. Sorry for the stupid question. I should've looked over it more.

Collectives™ on Stack Overflow

Unexpected Identifier Javascript SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related