joining shp and dbase files

[Alberto Gomez]

 Hi Emil,

   Thank you for your quick response. It works great!!... but in local. I'm
 working in windows and my dbf file is located in a network volume (Z:). I
 set DATA parameter with a full path like this:
 "/inetpub/wwwroot/project/data/myfile.dbf" and i need to change from "C:"
to
 "Z:".

   Could you helpme with that?

   Tanks in advance,
    Alberto





> ----- Original Message -----
> From: "Emil Zegers" <taatuut at PLANET.NL>
> To: <MAPSERVER-USERS at LISTS.UMN.EDU>
> Sent: Thursday, May 26, 2005 9:12 AM
> Subject: Re: [UMN_MAPSERVER-USERS] joining shp and dbase files
>
>
> > Hello Alberto,
> >
> > You cannot use the MapServer JOIN to classify and display attributes
from
> > the join table (see bug
> > http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=674).
> >
> > So the JOIN function for a LAYER has not disappeared but is not suited
for
> > this purpose.
> >
> > You could try using OGR JOIN however.
> >
> > OGR SQL supports a limited form of one to one JOIN.
> >
> > Somehting like:
> >
> > CONNECTIONTYPE OGR
> > CONNECTION "data/popplace_pt"
> > DATA "SELECT columns FROM table LEFT JOIN some join statement"
> >
> > Take a look at the JOIN examples at
> > http://www.remotesensing.org/gdal/ogr/ogr_sql.html
> >
> > Regards,
> >
> > Emil
> >
> >
> > -----Original Message-----
> > From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On
> > Behalf Of Alberto Gomez
> > Sent: donderdag 26 mei 2005 9:01
> > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: [UMN_MAPSERVER-USERS] joining shp and dbase files
> >
> > Hello list,
> >
> > I'm using mapserver as cgi and I need to do a color classification by a
> > field in the dbase table, so that I can see any modification in this
table
> > at real time in my map server.
> >
> > I've tried to do a join between my shapefile and dbase table but the
layer
> > disappeared. All that I've read is that Join function in mapfile is no
> > longer available. Is there any other way to do this? Can you post an
> > example?
> >
> > Thanks in advance.
> >
> >
> >
>
>
> >
>