Sorry, I meant the DATA statement. Umberto
On 8/21/07, Umberto Nicoletti <[EMAIL PROTECTED]> wrote: > You probably have to add the columns in the CONNECTION STATEMENT. > > Umberto > > On 8/21/07, HarryS <[EMAIL PROTECTED]> wrote: > > this is the layer configuration: > > > > LAYER > > NAME "City-Database" > > GROUP "Databases" > > STATUS default > > DATA "the_geom from name" > > CONNECTION "user=postgres dbname=geonamesallppl host=localhost > > port=5432" > > CONNECTIONTYPE postgis > > TYPE QUERY > > > > > > CLASS > > TEMPLATE "template-city.html" > > NAME "City-Database" > > END > > > > METADATA > > "queryable" "true" > > "searchfield" "name" > > "fields" > > "name:Name,population:Pop,country:Country,province:Province,CODE:Code" > > END > > > > END > > > > > > Mapserver can render maps using this layer and also searching via > > KaMap-Frontend works on this layer, only itemnquery via cgi gives me the > > above quoted error. I tried using different cases with column names (NAME, > > Name, name) but always got same error: ...ERROR: Column »london« does not > > exist... > > This I don't understand because »london« is the querystring and not the > > column-name. > > > > Thanks, > > Harry > > > > > > > > > > > > Umberto Nicoletti wrote: > > > > > > Please post the layer configuration for postgis AND check the case of > > > the column name. > > > Postgres handles column names with case sensitivity if, at table > > > creation, the column name was in quotes. In that case you have the > > > specify the column name with exactly the same case and in quotes; this > > > is most likely the reason. > > > > > > HTH, > > > Umberto > > > > > > On 8/21/07, HarryS <[EMAIL PROTECTED]> wrote: > > >> doing this query: > > >> > > >> http://myServer.com/cgi-bin/mapserv?&map=/home/harry/Mapfiles/MyMap.map&mode=itemnquery&qlayer=City-Database&qitem=NAME&qstring='London' > > >> > > >> produces this Error: > > >> > > >> prepare_database(): Query error. Error executing POSTGIS DECLARE (the > > >> actual > > >> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT > > >> NAME::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text > > >> from name WHERE (London) and (the_geom && setSRID( 'BOX3D(-180 -90,180 > > >> 90)'::BOX3D,find_srid('','name','the_geom') ))' > > >> > > >> Postgresql reports the error as 'FEHLER: Spalte »london« existiert nicht > > >> ' > > >> (Translation: ERROR: Column »london« does not exist) > > >> > > >> More Help: > > >> > > >> Error with POSTGIS data variable. You specified '<check your .map file>'. > > >> Standard ways of specifiying are : > > >> (1) 'geometry_column from geometry_table' > > >> (2) 'geometry_column from (<sub query>) as foo using unique <column name> > > >> using SRID=<srid#>' > > >> > > >> Make sure you put in the 'using unique <column name>' and 'using SRID=#' > > >> clauses in. > > >> > > >> For more help, please see http://postgis.refractions.net/documentation/ > > >> > > >> Mappostgis.c - version of Jan 23/2004. > > >> > > >> > > >> If I do the same query on the same layer but using a shapefile instead of > > >> PostGIS for identical data the query works fine without any errors. Can > > >> someone point me to my mistake, please ? > > >> > > >> Harry Schmidt > > >> > > >> > > >> -- > > >> View this message in context: > > >> http://www.nabble.com/Error-on-Itemnquery-with-PostGIS-layer-tf4303941.html#a12250916 > > >> Sent from the Mapserver - User mailing list archive at Nabble.com. > > >> > > > > > > > > > > -- > > View this message in context: > > http://www.nabble.com/Error-on-Itemnquery-with-PostGIS-layer-tf4303941.html#a12252666 > > Sent from the Mapserver - User mailing list archive at Nabble.com. > > >
