projects
/
fusionforge
/
fusionforge.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Fixed SQL syntax
[fusionforge/fusionforge.git]
/
src
/
utils
/
ffcountries.pl
diff --git
a/src/utils/ffcountries.pl
b/src/utils/ffcountries.pl
index 6be392d5470ae35a2ca6f3742b1cdb55af42a96d..90d3966aa1caf692aa0e162e304beddada1e7f70 100755
(executable)
--- a/
src/utils/ffcountries.pl
+++ b/
src/utils/ffcountries.pl
@@
-21,5
+21,6
@@
foreach (`isoquery -c`) {
chomp ;
my $cc = substr($_,0,2);
$_ =~ s/.*\t//;
- print "INSERT INTO country_code VALUES (\"$_\",'$cc');\n";
+ $_ =~ s/'/''/g;
+ print "INSERT INTO country_code VALUES ('$_','$cc');\n";
}