Skip to content

Tag: insert

having trouble inserting values into table with syntax error

Everytime at around “composedLine = String.format(“%s, %s, %s, %s, %s”, composedLine, values[0], values[1], values[2], values[3]);” it produces “INSERT INTO airport VALUES (, ABR, Aberdeen Regional Airport, Aberdeen” instead of “INSERT INTO airport VALUES (ABR, Aberdeen Regional Airport, Aberdeen” which causes a syntax error when I use executeupdate due to the “,” before the ABR. Answer This code is a security