OGR Join and class {Scanned}

[Siki Zoltan]

Dear Emil,

Thanks for your suggestions.
Defining the CLASSITEM without table name prefix (either lowercase or
uppercase) results "Invalid Field name: mycol" :(

I think I've tried all combinations.


Bye
Zoltan

On Fri, 27 May 2005, Emil Zegers wrote:

> Hello Siki,
>
> Have you tried defining the CLASSITEM without the table name prefix and/or
> switching column name to lowercase:
>
> CLASSITEM "MYCOL"
>
> or
>
> CLASSITEM "mycol"
>
> or maybe
>
> CLASSITEM "ms.mycol"
>
> Regards,
>
> Emil
>
>
> -----Original Message-----
> From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On
> Behalf Of Siki Zoltan
> Sent: donderdag 26 mei 2005 22:56
> To: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: [UMN_MAPSERVER-USERS] OGR Join and class {Scanned}
>
>
> Hi,
>
> I would like to define classes based on an OGR Joined (ODBC) column.
> I was not able to make the class definitions.
> My layer definition looks like:
>
> LAYER
>   NAME test
>   CONNECTIONTYPE OGR
>   CONNECTION kafold.shp
>   DATA "SELECT kafold.*, ms.* FROM kafold LEFT JOIN
> 'ODBC:admin/xxx at mydb'.ms ON kafold.hrsz=ms.hrsz"
>   TYPE POLIGON
>   STATUS DEFAULT
>   CLASSITEM "ms.MYCOL"
>   CLASS
>     EXPRESSION /x/
>     COLOR 255 0 0
>     OUTLINECOLOR 0 0 0
>   END
> END
>
> If I remove CLASSITEM and EXPRESSION line the layer is drawn, so the DATA
> definition is good.
> I also tried to to remove CLASSITEM and give an expression like
> EXPRESSION ('[ms.MYCOL]' = 'x')
>
> I get an error massage in the apache error log
> libpng warning Incomplete compressed datastream in iCCP  chunk
>
> Any idea?
>
> Thanks
> Zoltan
>