Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte
archivos de configuración:
Archivo .map
LAYER
CONNECTIONTYPE postgis
DATA "the_geom from v_callepuerta USING UNIQUE gid
USING SRID=32721"
TYPE point
CONNECTION "user=montevimap password=xxx
dbname=nucleo host=desgis.imm.gub.uy port=5432"
NAME "busqueda"
STATUS OFF
DUMP TRUE
END
Archivo search.xml
<searchitem name="busqueda" description="Calle y Nº de puerta">
<layer type="postgis" name="busqueda">
<field type="s" name="nom_calle" description="Calle"
wildcard="0">
<definition type="suggest" connectiontype="db"
sort="asc"
minlength="1" dependfld="cmcncd">
<dsn
encoding="UTF-8">pgsql://montevimap:x...@desgis.imm.gub.
uy/nucleo</dsn>
<sql> SELECT nom_calle FROM v_callepuerta WHERE
nom_calle
='[search]' </sql>
</definition>
</field>
<field type="n" name="num_puerta" description="Numero
de Puerta" wildcard="2">
<definition type="suggest" connectiontype="db"
sort="asc" minlength="1" dependfld="cmcncd">
<dsn encoding="UTF-8">pgsql:
//montevimap:x...@desgis.imm.gub.uy/nucleo</dsn>
<sql>SELECT num_puerta FROM
v_callepuerta WHERE num_puerta ='[search]' </sql>
</definition>
</field>
</layer>
</searchitem>
Definición tabla postgrs.
Columna | Tipo | Modificadores
----------------+-------------------+---------------
gid | bigint |
cod_nombre_via | integer |
nom_calle | character varying |
num_puerta | integer |
letra | character(5) |
paridad | character(1) |
the_geom | geometry
Muchas gracias por cualquier ayuda, otras busquedas si me funcionan
pero no logro que esta funciones.
Richard
Montevideo, Uruguay
English
Dear Nahum, pmapper version is 4 stable, attached some configuration
files:
Archive. Map
LAYER
CONNECTIONTYPE postgis
DATA "the_geom from v_callepuerta USING UNIQUE gid
USING SRID = 32721"
TYPE point
CONNECTION "user = montevimap password = xxx dbname =
nucleo desgis.imm.gub.uy host = port = 5432"
NAME "Search"
STATUS OFF
DUMP TRUE
END
File search.xml
<searchitem name="busqueda" description="Calle and Nº of puerta">
<layer type="postgis" name="busqueda">
<field type="s" name="nom_calle" description="Calle" wildcard="0">
<definition type="suggest" connectiontype="db" sort="asc" minlength="
1" dependfld="cmcncd">
<dsn encoding="UTF-8"> pgsql: / / montevimap:x...@desgis.imm.gub.uy
/nucleo </ dsn>
nom_calle SELECT <sql> FROM v_callepuerta WHERE nom_calle = '[search]'
</ sql>
</ definition>
</ field>
<field type="n" name="num_puerta" description="Numero
of Puerta" wildcard="2">
<definition type="suggest" connectiontype="db"
sort="asc" minlength="1" dependfld="cmcncd">
<dsn encoding="UTF-8"> pgsql: / /
montevimap:x...@desgis.imm.gub.uy /nucleo </ dsn>
num_puerta SELECT <sql> FROM
v_callepuerta WHERE num_puerta = '[search]' </ sql>
</ definition>
</ field>
</ layer>
</ searchitem>
Definition postgres table.
Column | Type | Modifiers
---------------- ------------------- ---------------
gid | bigint |
cod_nombre_via | integer |
nom_calle | character varying |
num_puerta | integer |
letter | character (5) |
parity | character (1) |
the_geom | geometry
Thank you very much for any help, if I run other searches but can not
get these functions.
Richard
Montevideo, Uruguay
Spanish
¿Cómo tienes definido tu .map y el archivo de configuración de
búsquedas?
¿Qué versión de pmapper tienes?.
English
How is defined your .map file and search.xml file?
Wich pmapper version you have?
Saludos.
Nahum
2010/1/20 richardcam...@adinet.com.uy <richardcam...@adinet.com.uy>
- Ocultar texto citado -
> llo everyone, sorry for my English.
> I have configured and installed the viewer pmapper, the only problem
I
> have is with the search, the same achievements on Postgres with
> PostGIS, work correctly on some tables, but in others does not
search
> me.
> I use both geometry tables or views both with the corresponding
column
> the_geom and gid.
> The log tells me that there is an error with the gid, but it exists
> and it's OK, I can properly display the layer in the map view.
> Deputy log with errors.
>
> [20-Jan-2010 17:27:17] PHP Warning: pg_query () [<a href='function.
pg-
> query'> function.pg-query </ a>]: Query failed: ERROR: syntax error
> at or near "FROM" at character 257 in / inetpub / wwwroot / maps /
> incphp / query / squery.php on line 704
> [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid,
> xmin (box3d (the_geom)),
> ymin (box3d (the_geom)),
> xmax (box3d (the_geom)),
> ymax (box3d (the_geom)),
>
> FROM x_sig_busqueda
> WHERE nom_calle ILIKE '% COLONIA%'
> LIMIT 301
> [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument
> is not a valid PostgreSQL result resource in / inetpub / wwwroot /
map
> s / incphp / query / squery.php on line 708
>
>
> Thank you very much for any help.
> Greetings
> Richard
>
>
>
------------------------------------------------------------------------------
> Throughout its 18-year history, RSA Conference consistently attracts
the
> world's best and brightest in the field, creating opportunities for
> Conference
> attendees to learn about information security's most important
issues
> through
> interactions with peers, luminaries and emerging and established
companies.
> http://p.sf.net/sfu/rsaconf-dev2dev
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
