[mapserver-users] SQL Statement is truncuated at about 2000 bites

Rotenhan von, Wernher Wernher.Rotenhanvon at suedzucker.de
Mon Sep 10 10:10:25 PDT 2012


Sometimes it's not so easy to use a view since the map parameters are used in Functions within the sql statement and those function shouldn be called to often 

Regards Wernher

-----Original Message-----
From: Puneet Kishor [mailto:punk.kish at gmail.com] 
Sent: Monday, September 10, 2012 6:35 PM
To: Rotenhan von, Wernher
Cc: 'mapserver-users at lists.osgeo.org'
Subject: Re: [mapserver-users] SQL Statement is truncuated at about 2000 bites


On Sep 10, 2012, at 9:22 AM, "Rotenhan von, Wernher" <Wernher.Rotenhanvon at suedzucker.de> wrote:

> When I use long SQL statements in my data statement (mapserver map file) they are cut at about 2000 bites and thus can not be executed.


Make a view, and then call the view.



--
Puneet Kishor


The information contained in this email is confidential. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, reproduction, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately.



More information about the mapserver-users mailing list