[mapserver-users] Unknown identifier-problems with join

[mikee]

woking with the win32 binarys

here my *.map-file

#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 500 500
#EXTENT 388107.634400379 5203120.88405952 500896.339019834 5310243.30613897
EXTENT -10 -10 10 10
UNITS METERS
SHAPEPATH "data"
IMAGECOLOR 255 255 255

#
# Start of web interface definition (including WMS enabling metadata)
#
WEB
  HEADER demo_header.html
  TEMPLATE demo.html
  FOOTER demo_footer.html
  MINSCALE 100
  MAXSCALE 10000000
  IMAGEPATH "set in demo_init.html"
  IMAGEURL "set in demo_init.html"
  METADATA
    WMS_TITLE "HALLE Demo"
    WMS_ABSTRACT "This is the UMN MapServer demonstration application for
HALLE."
    WMS_ACCESSCONSTRAINTS none

    # change this value to match your setup
    WMS_ONLINERESOURCE "http://admp09/mapserver/demo_init.html"

    WMS_SRS "EPSG:26915"
  END
END

QUERYMAP
  SIZE 300 300
  STATUS ON
  STYLE HILITE
  COLOR 255 0 0
END

#
# Start of reference map
#
REFERENCE
  IMAGE graphics/halle_ref.gif
  #EXTENT 393234.393701263 5205405.16440722 495769.579718949
5307959.02579127
  EXTENT -10 -10 10 10  SIZE 120 120
  STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
END

#
# Start of legend
#
LEGEND
  KEYSIZE 18 12
  LABEL
    TYPE BITMAP
    SIZE 1
    COLOR 0 0 0
  END
  STATUS ON
END

#
# Start of scalebar
#
SCALEBAR
  IMAGECOLOR 255 255 255
  LABEL
    COLOR 255 255 255
    SIZE tiny
  END
  STYLE 1
  SIZE 100 2
  COLOR 255 255 255
  UNITS METERS
  INTERVALS 2
  TRANSPARENT TRUE
  STATUS TRUE
END

#
# Start of symbol definitions (we're only using a few)
#
SYMBOL
  NAME 'circle'
  TYPE ELLIPSE
  POINTS 1 1 END
  FILLED TRUE
END

#
# Start of layer definitions
#


# --------------------------------------------------------------------


LAYER
   NAME test
   TYPE POLYGON
   STATUS DEFAULT
   DATA test1
   CLASS
     NAME  "test"
     EXPRESSION ([NR] > 0)
     SYMBOL 1
     COLOR 32 201 32
     OUTLINECOLOR 0 0 0
   END
END

LAYER
   NAME test
   TYPE POLYGON
   STATUS DEFAULT
   DATA test1
   CLASS
     SYMBOL 0
     COLOR 255 30 2
     OUTLINECOLOR 0 0 0
   END
   #QUERYITEM "NR"
   QUERY
     EXPRESSION ([NR] > 0)
     template site_detail.html
     JOIN
       table "join1.dbf"
       from "NR"
       to "NR"
     END # join
   END
END


END # Map File


and here the errors

loadLayer(): Unknown identifier. (QUERYITEM):(127)
loadLayer(): Unknown identifier. (QUERY):(128)

where is my error??

--->    mfg mikeE. :-)