# HG changeset patch
# User Michael Stanko <mstanko@bfs.de>
# Date 1483540607 -3600
# Node ID c0db68c9a87dd8cf7a6a56858fb6f2a3ba781a4c
# Parent  23b75545dbf0df874ab1895038d03573e9b46110
enable new-line in sql text of queries

diff -r 23b75545dbf0 -r c0db68c9a87d src/main/java/de/intevation/lada/model/stammdaten/Query.java
--- a/src/main/java/de/intevation/lada/model/stammdaten/Query.java	Mon Dec 19 11:31:33 2016 +0100
+++ b/src/main/java/de/intevation/lada/model/stammdaten/Query.java	Wed Jan 04 15:36:47 2017 +0100
@@ -80,7 +80,8 @@
     }
 
     public String getSql() {
-        return this.sql;
+        // remove \r and \n from sql text
+        return this.sql.replaceAll("(\r\n|\n)", " ");
     }
 
     public void setSql(String sql) {