X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/a61350bc7ddd403460f79498a48e07f101fc2067..259a4169f1bc8ece69ff289df7a47e0d84f4d418:/procmail/sql-escape

diff --git a/procmail/sql-escape b/procmail/sql-escape
index 08d0903..c8bb8c9 100644
--- a/procmail/sql-escape
+++ b/procmail/sql-escape
@@ -1,17 +1,14 @@
-SQ="'\\''"
-SQE="'\\\''"
-
 :0
 * DATA ?? .
-{ 
+{
+  # 1. replace ' with ''
+  # 2. add quotes to each line
+  # 3. swap comma outside
   DATA="`echo \"$DATA\" \
-    | sed -re 's,'\'','$SQE$SQE',g;' \
-          -e  's/^.*$/'\$SQE'&'\$SQE'/' \
-          -e  's/,'$SQE'$/'\$SQE',/'`"
+    | sed -re \"s,','',g\" \
+           -e \"s/^.*$/'&'/\" \
+           -e \"s/,'$/',/\"`"
 }
 
 :0 E
 { LOG="sql-escape:  WARNING: no \$DATA provided!$NL" }
-
-SQE
-SQ