Error load from database

[Clint Johnson]

Take out your CLASSITEM line, or modify it so that it works.

Recall that <name> in "CLASSITEM <name>" must be the name a column which 
exists within your table; not the name of the table.


Clint

-- 
Clint Johnson
Refractions Research Inc.
Cjohnson at refractions.net


Alexander Rodriguez Torres wrote:
> I have these error when I load my map from database. Can you help me???
>
> ****************************************************************************
> msDrawMap(): Image handling error. Failed to draw layer named 'Contornos'. 
> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT contornos::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from contornos WHERE the_geom && setSRID('BOX3D(9387137.4 791043.7018,10119140.81 1522550.8382)'::BOX3D, find_srid('','contornos','the_geom') )' 
>
> Postgresql reports the error as 'ERROR: cannot cast type contornos to text '
> ****************************************************************************
>
> This is my .map
>
> MAP
>   NAME "Mapa de la UCI"
>   STATUS ON
>   EXTENT 9387137.4 805683.77 10119140.81 1507910.77 
>   SIZE 500 500 
>   SHAPEPATH "./data"
>   SYMBOLSET "./etc/symbols.sym"
>   FONTSET "./etc/fonts.txt"
>   IMAGETYPE PNG
>   IMAGECOLOR 174 183 207
>   UNITS METERS
>   TEMPLATEPATTERN "UCI"
>   WEB
>     MINSCALE 259371
>     IMAGEPATH "C:/temp/"
>     IMAGEURL "/tmp/"
>     HEADER "templates/header.html"
>     FOOTER "templates/footer.html"
>  END
>   REFERENCE
>     STATUS ON
>     IMAGE "images/keymap.png"
>     SIZE 88 69 
>     EXTENT 9387137.4 805683.77 10119140.81 1507910.77 
>     COLOR -1 -1 -1
>     OUTLINECOLOR 255 0 0
>     MINBOXSIZE 3
>     MAXBOXSIZE 0
>     MARKER 0
>     MARKERSIZE 0
>   END
>   QUERYMAP
>     STATUS OFF
>     SIZE -1 -1 
>     COLOR 255 0 0
>     STYLE HILITE
>   END
>   #
>   # Start of legend object
>   #
>   LEGEND
>     STATUS ON
>     IMAGECOLOR 255 255 255
>     POSITION LL
>     KEYSIZE 18 12 
>     KEYSPACING 5 5 
>     TEMPLATE "ttt"
>     LABEL
>       TYPE BITMAP
>       SIZE MEDIUM
>       OFFSET 0 0 
>       BUFFER 0
>       MINDISTANCE -1
>       MINFEATURESIZE -1
>       COLOR 0 0 89
>       PARTIALS TRUE
>       FORCE FALSE
>     END
>   END
>   #
>   # Start of scalebar object
>   #
>   SCALEBAR
>     STATUS ON
>     COLOR 255 255 255
>     OUTLINECOLOR 0 0 0
>     BACKGROUNDCOLOR 0 0 0
>     IMAGECOLOR 255 255 255
>     UNITS KILOMETERS
>     INTERVALS 5
>     SIZE 150 5 
>     STYLE 0
>     POSITION LL
>     LABEL
>       TYPE BITMAP
>       SIZE SMALL
>       OFFSET 0 0 
>       BUFFER 0
>       MINDISTANCE -1
>       MINFEATURESIZE -1
>       COLOR 0 0 0
>       PARTIALS TRUE
>       FORCE TRUE
>     END
>   END
>   #
>   # Start of OutputFormat object
>   #
>   OUTPUTFORMAT
>     NAME "png"
>     MIMETYPE "image/png"
>     DRIVER "GD/PNG"
>     EXTENSION "png"
>     IMAGEMODE PC256
>     TRANSPARENT FALSE
>   END
>   LAYER
>     NAME "Contornos"
>     STATUS ON
>     CONNECTIONTYPE POSTGIS
>     CONNECTION "user=postgres password=post dbname=siguci host=localhost"
>     CLASSITEM "contornos"
>     DATA "the_geom from contornos"
>     TYPE POLYGON    
>     CLASS
>       NAME "contornos"
>       TEMPLATE ""
>       STYLE
>         SYMBOL 0
>         COLOR 0 128 0
>         OUTLINECOLOR 0 0 0
>       END
>    
>
>     END
>
> Alexander Rodríguez Torres.
>  Estudiante de Quinto Año.
>   Universidad de las Ciencias Informáticas.
>    E-mail:atorres at estudiantes.uci.cu 
>