[Geomoose-users] POSTGIS CONNECTION FAIL

[John Kummun]

Hey guys,
When i try to get date(police) from database(postgis), i get this error message. Can someone explain to me what is going on here? the column NAME does exist in the attribute table
 
msDrawMap(): Image handling error. Failed to draw layer named 'Police'. prepare_database(): Query error. Error declaring cursor: ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor BINARY CURSOR FOR SELECT "NAME"::text,asbin... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT "NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from police WHERE the_geom && setSRID('BOX3D(337927.246357327 1652890.274125,468593.724439673 1759026.124282)'::BOX3D, find_srid('','police','the_geom') ) 
 
This is the mapfile
LAYER
 NAME 'Police'
     CONNECTIONTYPE postgis
     CONNECTION 'user=postgres password=boachef19578 dbname=postgis            host=localhost'
     DATA 'the_geom from police using unique gid'
     STATUS DEFAULT
     TYPE POINT
           CLASS
           NAME 'Police'
           STYLE
              SYMBOL 'star'    
              SIZE 6
              WIDTH 1
             END
       END
    End
 
Bernard
Indiana



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20081028/b2165d76/attachment.html