Tach,

problem ist jetzt: ich habe leerzeilen in den dinger die ich in die zellen der tabelle schreiben möchte, also in args[0][2] - was kann ich da tun?

kontextgerecht escapen

mfg
Woodfighter

hm...

ich hab jetzt alle leerstellen rausgezogen, komischer weise bricht er bei 7 ab, aber zwischen 1 und 7 ist kein zeichen:

'2011-11-1713:44:48.702000000-2011-12-3010:18:05.419000000'
SQL Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Bisheriger Nutzen',Zeitraum) values ("2132153359100255838", "135.0","'2011-11-1' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Bisheriger Nutzen',Zeitraum) values ("2132153359100255838", "135.0","'2011-11-1' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2728)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2678)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
at GUI.Main.InMySQL(Main.java:69)
at GUI.Main.main(Main.java:39)