[chronojump] Better MakeValidSQL code



commit ca7c3f3e35379959154848f230d8c83bd4633701
Author: Xavier de Blas <xaviblas gmail com>
Date:   Sun Jul 23 20:38:24 2017 +0200

    Better MakeValidSQL code

 src/util.cs |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)
---
diff --git a/src/util.cs b/src/util.cs
index 453acae..9b86c42 100644
--- a/src/util.cs
+++ b/src/util.cs
@@ -296,8 +296,17 @@ public class Util
        }
        public static string MakeValidSQL(string str)
        {
+               /*
+                * This code sometimes does not work with '
+                * below code is better
                char [] trimChars = {'"','\''};
                return str.Trim(trimChars);
+               */
+
+               StringBuilder myStringBuilder = new StringBuilder(str);
+               myStringBuilder.Replace("'", "");
+               myStringBuilder.Replace("\"", "");
+               return myStringBuilder.ToString();
        }
 
        //to pass latin chars to JSON


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]