Try to use <layer type="xy".../> armin
luis alfios wrote: > Hi, > > I am loading a layer from a MS Access table, named "tabla_ejemplo" with a > text field called "nombre" and the x and y fileds, using the following for > this in the .map file: > METADATA > "DESCRIPTION" "layer XY" > "RESULT_FIELDS" "nombre, direccion" > "RESULT_HEADERS" "NAME, ADDRESS" > "XYLAYER_PROPERTIES" "odbc://'':''/[EMAIL PROTECTED] > ||tabla_ejemplo||x,y,0" > END # Metadata > > The layer is correctly displayed but I wanna to know how to define the > attribute type of the search file for this layer, is the next code right? > ,must the type field value be "odbc"? > > <searchitem name="layerXY" description="Capa XY"> > <layer type="odbc" name="layerXY"> > <field type="s" name="nombre" description="Introduzca nombre:" > wildcard="0" /> > </layer> > </searchitem> > > I get the next error in the pmapper error file when I try to search over the > layer: > > [07-Sep-2007 14:48:13] ===== P.MAPPER: DB ERROR ===== > Standard Message: DB Error: syntax error > DBMS/Debug Message: SELECT x, y, nombre FROM tabla_puntos WHERE ( > "[nombre]" =~ /(D|d)/) [nativecode=37000 [Microsoft][Controlador ODBC > Microsoft Access] Error de sintaxis en la expresión de consulta '( > [[nombre]] =~ /(D|d)/)'.] > > > Thanks > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
