[chronojump] Better MakeValidSQL code
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump] Better MakeValidSQL code
- Date: Sun, 23 Jul 2017 18:39:31 +0000 (UTC)
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]