Hi,
I am also be interested in learning how to use boolean
attributes in filter expressions.
I have also tried to get a filter expression with a
boolean attribute to work, but have had no luck. My
data source was PostGIS.
I did a workaround in SQL to get integers instead
(CASE WHEN booleanvariable = 'f' then 0 else 1).
Håvard
On 10/26/2012 3:26 PM, Brian Fischer wrote:
Hi,
I am trying to use a filter expression to only display features where a value
is true in a Boolean field coming from an MSSQL Spatial datasource. It seems
like every syntax I try MapServer comes back with “An expression of non-boolean
type specified in a context where a condition is expected”
I have tried a number of different combinations. How do you specify a Boolean
expression? Has anyone got a Boolean field type to work from a database source?
If so what expression did you use?
Thanks!
*Brian Fischer, CFM***
Principal | GIS Project Manager
*O* 763.493.4522 | *D* 763.493.6664 | *M* 763.229.2734
cid:[email protected]
6901 E Fish Lake Rd. , Suite 140 • Maple Grove, MN • 55369
*www.houstoneng.com* <http://www.houstoneng.com/>* ***
This entire message (including all forwards and replies) and any attachments
are for the sole use of the intended recipient(s) and may contain proprietary,
confidential, trade secret, work-product, attorney-client or privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited and may be a violation of law. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies of
the original message.
--
Håvard Tveite
Department of Mathematical Sciences and Technology, UMB
Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt/
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
