OGR Join and class {Scanned}

[Alberto Gomez]

Try with this:

'ODBC:admin/xxx at mydb'.ms ms ON kafold.hrsz=ms.hrsz"
                                                ^
                                                ^




----- Original Message -----
From: "Siki Zoltan" <siki at agt.bme.hu>
To: "Alberto Gomez" <agomez at CCCMM.CESGA.ES>
Cc: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Friday, May 27, 2005 11:17 PM
Subject: Re: [UMN_MAPSERVER-USERS] OGR Join and class {Scanned}


> Hi Alberto,
>
> Thanks for your suggestion.
> Changing the table name results "Invalid Fiels name: kafold.MYCOL"
>
> Bye
> Zoltan
>
> On Fri, 27 May 2005, Alberto Gomez wrote:
>
> > Hi Siki,
> >
> >     Try to replace
> >
> >          >   CLASSITEM "ms.MYCOL"
> >
> >     by   CLASSITEM "kafold.MYCOL"
> >
> > I hope this help,
> > Alberto
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Siki Zoltan" <siki at AGT.BME.HU>
> > To: <MAPSERVER-USERS at LISTS.UMN.EDU>
> > Sent: Thursday, May 26, 2005 10:55 PM
> > 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
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>