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, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Programmer for Rent
