Sunday 15 August 2010

java - Insert into statement with parentheses in column names -


I am using Java to put in a MSSQL database. I have column names with parentheses such as duration_ (minutes) .

I am trying to execute a statement like this:

INSERT in mytable (duration_ (minutes)) value (?)

And I'm getting the following error:

Exception in thread "main" java.sql.SQLException: '('

is wrong Syntax is why I think I need some way to avoid brackets?

No comments:

Post a Comment