expressions problem with Postgis

[Carola Jesch]

Dear All,
 
I have been running into a problem splitting a postgresql layer into two
classes via MapServer expressions and I am hoping someone of you can help
me.
 
I have a postgresql table containing roads. There is a column 'name' where
you can see the road's status like 'Interstates' or 'State Routes'. So far
so good. But (there is always a 'but :-) )...
some records are looking like that:
Interstate Route 75, State Route 401

I tried to seperate my classes with some MapServer expression. I succeeded
in getting the Interstates by:

CLASS

  NAME       "Interstates"    
  EXPRESSION ("[name]" =~ /Interstate/)  

...


Now I want to seperate the State Routes by filtering all records that DO NOT
contain the substring "Interstates".

CLASS

  NAME       "Interstates"    
  EXPRESSION ("[name]" !=~ /Interstate/)  

...

It isn't working :-(. The documentation doesn't tell anything about this
case. Do you have any tip?

Thanks, Carola

  _____  

From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Chau,Philip [PYR]
Sent: Monday, January 09, 2006 11:50 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] SLD http header problem




I'm trying to display the layer and using SLD to change the symbol
(ActiveFedProv) and it seems to be giving me a problem

 
<http://excise.pyr.ec.gc.ca/cgi-bin/pyrwqmp.asp?version=1.1.1&service=WMS&re
quest=GetMap&layers=ActiveFedProv&SLD=http://map.ns.ec.gc.ca/kyw/sld/kyw_sld
.xml>
http://excise.pyr.ec.gc.ca/cgi-bin/pyrwqmp.asp?version=1.1.1&service=WMS&req
uest=GetMap&layers=ActiveFedProv&SLD=http://map.ns.ec.gc.ca/kyw/sld/kyw_sld.
xml

WMS GetCapabilities seems to say that it supports SLD however I get a CGI
error 

"CGI Error 
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:

" 

Cheers, 
Phil 


Philip Chau, PMP 
Water Quality Monitoring Division 
Environmental Stewardship Branch 
Environment Canada 
201-401 Burrard Street 
Vancouver, BC V6C 3S5 
Tel: 604.664.4066 
Fax: 604.664.9126 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060109/5361939c/attachment.htm>