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:[email protected]] 
Sent: Monday, September 10, 2012 6:35 PM
To: Rotenhan von, Wernher
Cc: '[email protected]'
Subject: Re: [mapserver-users] SQL Statement is truncuated at about 2000 bites


On Sep 10, 2012, at 9:22 AM, "Rotenhan von, Wernher" 
<[email protected]> 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.

_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to