[Mapserver-users] JOIN problem

[Rebecca Colwell]

Hey Randy,

Yes, it displays my US shapefile when I comment out that line.  What 
does this tell you?

Thanks!

~Becky

Randy James wrote:

> Hi
> 
> Will it work if you do not filter it by 'Disfchmt_R' ?
> 
> Randy
> --- Rebecca Colwell <colwell at geog.umn.edu> wrote: > Hi,
> 
>>I'm trying to work through building one of my first .map
>>files, and have 
>>hit a wall.  I can't seem to figure out how to do a
>>one-to-one join.  I 
>>keep getting the error messages:
>>
>>msDrawMap(): Image handling error. Failed to draw layer
>>named 'states'.
>>msDBFGetItemIndex(): DBASE file error. Item 'Disfchmt_R'
>>not found.
>>
>>I triple checked the .dbf I'm trying to join, and that is
>>the name of 
>>the attribute field I want to access.
>>
>>Below is my short bit of code so far.  I would be so
>>thankful if anyone 
>>could guide me in the right direction on how to get it to
>>work.
>>
>>~Becky
>>
>>
>>MAP
>>   IMAGETYPE      PNG24
>>   EXTENT         -2153561.581984760 4847233.565621579
>>2641846.236294404 
>>-6178805.564371807
>>   SIZE           800 500
>>   SHAPEPATH      "data"
>>   IMAGECOLOR     203 201 226
>>
>>   PROJECTION
>>     "proj=laea"
>>     "ellps=clrk66"
>>     "lat_0=45"
>>     "lon_0=-100"
>>   END
>>
>>   # Start of LAYER DEFINITIONS 
>>---------------------------------------------
>>   LAYER # States polygon layer begins here
>>     NAME         states
>>     DATA         STATES
>>     STATUS       DEFAULT
>>     TYPE         POLYGON
>>
>>     PROJECTION
>>       "init=epsg:4326"
>>     END
>>
>>     JOIN
>>     	NAME 	"Felon Ethnicity"
>>	TABLE	"data/FelonEthnicity.dbf"
>>	FROM 	"STATE_NAME"
>>	TO 	"STATE"
>>     	TYPE 	single
>>     END #Join
>>
>>     CLASS
>>	NAME "<21%"
>>	EXPRESSION ('[Disfchmt_R]' <= .021)
>>	COLOR 242 240 247
>>	OUTLINECOLOR 200 200 200
>>       COLOR        232 232 232
>>       OUTLINECOLOR 32 32 32
>>     END
>>
>>   END # States polygon layer ends here
>>   # End of LAYER DEFINITIONS
>>-------------------------------
>>
>>END # end of map file/object
>>
>>
>>_______________________________________________
>>Mapserver-users mailing list
>>Mapserver-users at lists.gis.umn.edu
>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>> 
> 
> 
> ______________________________________________________________________ 
> Post your free ad now! http://personals.yahoo.ca
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users