Topic: MySQL and filepath
I'm trying to use the Excelimport (http://myvisualdatabase.com/forum/viewtopic.php?id=5168) with mysql, but i have problems with inserting filepaths into the database because of specialcharacters (i guess) when it comes to the code
sqlexecute('insert into file_excel (path,record) values ("'+escape_special_characters(sl2[t])]+'"),0)');
I 've commented this line out and then the error doesn't appear.
So iguess it has something to do with pecial Chatacters in the filename. it contains backslashes and underscore "_". How should the insert command look alike when using MySQL?