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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
