Greetings and salutations...
I am having a problem with an specific UPDATE. One of the functions of my
program is to capture all of the files in a directory so that one can search
on a file name and find out where that file is quickly. This is working
perfectly, until there is a file that has a single quote (') in its name.
Say a directory has these three files:
1. filename0.txt
2. filename1.txt
3. filename'3.txt
4. filename4.txt
my update string is this,
BEGIN;
UPDATE LSOpenProjects SET
Xtra0 = '',
... some other settings working ok ...
Xtra3 = '
filename0.txt
filename1.txt
filename''3.txt
filename4.txt
',
Xtra4 = '',
Xtra5 = '',
Xtra6 = '',
Xtra7 = '',
Xtra8 = '0.00',
Xtra9 = '',
XtraA = '',
XtraB = '',
XtraC = '',
XtraD = '',
XtraE = '',
XtraF = '' WHERE id = 3487;
COMMIT;
The column in question is Xtra3. If I rename that file to NOT contain the
single quote, the UPDATE works. Also, I add a newline (\n) to the beginning
of the first filename and a new line after every filename.
Any ideas?
thanks,
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
