Hi I am trying to do an insert query but for some reason although there
appears to be no exception thrown my data does not get into the database.
I will try to explain what I am doing
In SQL you can do the following sort of statement
INSERT INTO mytable (fname, lname, age) VALUES ('Joe', 'Bloggs
I have no idea where the backslashes are comming from... very strange.
Are you building your string, then printing it out and it has
backslashes in it from nowhere?
Also, you should probably use a PreparedStatement for this, it will
handle everything for you:
String sqlQuery = "INSERT INTO myt
