problem with ogr ovf connection

[Frank Warmerdam]

Janeks Kamerovskis wrote:
> 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?

Janeks,

Could you provide the OVF file in question?  A couple possibilities come
to mind:
  o The < sign may need to be escaped in the XML OVF file (as <).
  o If this is the contents of a SrcSQL you will need a WHERE statement won't
    you?

Perhaps I am misunderstanding what you mean when you talk about adding
the above field.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent