problem with ogr ovf connection
    Janeks Kamerovskis 
    janeks.kamerovskis at SILVA.LV
       
    Tue Feb 21 00:23:16 PST 2006
    
    
  
I had succesfuly set up ogr ovf connection, but problem appears when I added
following field:
case when round(sysdate - RS.CREATE_DATE) < 14 then 1 else (
	case when round(sysdate - RS.CREATE_DATE) < 28 then 2 else 3 end
) end as RSS_AGE_GR
Problem is not in query because it runs without any problems directly in
F.ex. MS Query analyzer.
When checking with ogrinfo I am getting following output:
ERROR 1: Line 14: Didn't find expected '=' for value of attribute 'then'.
FAILURE:
What could be done to solve this problem?
One I probably know - to create a view on SQL server. Are there others?
Thanks in advance!
Janeks
    
    
More information about the MapServer-users
mailing list