Erni35
15th September 2010, 16:28
Hi,
(surprise, surprise) I have a little problem.
I want to execute the following Query:
abfrage->exec("LOAD DATA LOCAL INFILE '/media/Daten/Qt4/kader3.csv' INTO TABLE " + DB->tabelle + "_kader FIELDS TERMINATED BY ';' IGNORE " + QString::number(beginn) + " LINES (@dummy1, @dummy2, @dummy3, @dummy4, @dummy5, @dummy6) SET sp_nr = @dummy1, name = CONCAT(@dummy2,', ', @dummy3), DRV_nummer = 'DE-00'");
Taken without the first quotes before and after the file name works. But no result in the database because of false SQL-Question. With the quotes I have a
Name des Signals :
SIGSEGV
Bedeutung :
Segmentation fault
Why? The query works with quotes in the MySQL-Query Browser.
Kindly,
Erni35
(surprise, surprise) I have a little problem.
I want to execute the following Query:
abfrage->exec("LOAD DATA LOCAL INFILE '/media/Daten/Qt4/kader3.csv' INTO TABLE " + DB->tabelle + "_kader FIELDS TERMINATED BY ';' IGNORE " + QString::number(beginn) + " LINES (@dummy1, @dummy2, @dummy3, @dummy4, @dummy5, @dummy6) SET sp_nr = @dummy1, name = CONCAT(@dummy2,', ', @dummy3), DRV_nummer = 'DE-00'");
Taken without the first quotes before and after the file name works. But no result in the database because of false SQL-Question. With the quotes I have a
Name des Signals :
SIGSEGV
Bedeutung :
Segmentation fault
Why? The query works with quotes in the MySQL-Query Browser.
Kindly,
Erni35