OGR Join and class {Scanned}

[Siki Zoltan]

Hi Alberto,

Thanks for your suggestion, but the alias name doesn't help.
Everything is working without any error, but mapserver doesn't see the
columns of the joined table (making thematic map or quering the layer).
I decided to write a program making the join. I have to use dinamic data
for the join.

Does anybody use ogr join in mapserver succesfully?

Thanks
Zoltan

On Mon, 30 May 2005, Siki Zoltan wrote:

> 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
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >
>