thank you chris,
i missed to mention the error log in my question, here the only message
i got:
error_pmapper.log:
[28-Nov-2013 11:36:39] P.MAPPER: PG Query error for : SELECT gid,
xmin(box3d(the_geom)),
ymin(box3d(the_geom)),
xmax(box3d(the_geom)),
ymax(box3d(the_geom)),
raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche
FROM schema02.e44_raeume
WHERE raumnr ILIKE '%' AND geschoss = -1
LIMIT 301
in pm_debug.log
[28-Nov-2013 10:36:59] P.MAPPER debug info
Parameters for searchParams
file: query.php->q_execAttributeQuery
Array
(
[layerName] => raeume
[layerType] => postgis
[firstFld] => raumnr
[qStr] => raumnr = *
)
[28-Nov-2013 10:36:59] P.MAPPER debug info
P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd:
SELECT gid,
xmin(box3d(the_geom)),
ymin(box3d(the_geom)),
xmax(box3d(the_geom)),
ymax(box3d(the_geom)),
raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche
FROM schema02.e44_raeume
WHERE raumnr = *
LIMIT 301
regards,
matthias moser
Am 28.11.2013 16:15, schrieb Chris forum:
> Hallo Matthias,
>
> Have a look at the pm_debug.log
> You should find there what request is sent to PGSQL.
>
> Regards,
> Chris
>
>
> On Thu, Nov 28, 2013 at 11:59 AM, <[email protected]
> <mailto:[email protected]>> wrote:
>
> dear pmapper users
>
> i have a table with field "raumnr" (numeric 3,2 unique) and field
> "gid"
> (integer as primary key).
> in the mapfile i have all the field names.
> my searchfile:
>
> <searchitem name="1" description="1 Untergeschoss">
> <layer type="postgis" name="e44_ug">
> <field type="n" name="raumnr" description="raumnr"
> wildcard="1" />
> </layer>
> </searchitem>
> if i use for the search the sign * to show all datas, this search
> does
> not function !
>
>
> if i take a string field, the search functions with wildcard 1 and *,
> the result table shows all fields:
>
> <searchitem name="1" description="1 Untergeschoss">
> <layer type="postgis" name="e44_ug">
> <field type="s" name="bezeichn" description="bezeichn"
> wildcard="1" />
> </layer>
> </searchitem>
>
> i cannot understand this behavior
>
> thank you for any help
>
> matthias moser
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business.
> Most IT
> organizations don't have a clear picture of how application
> performance
> affects their revenue. With AppDynamics, you get 100% visibility
> into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> AppDynamics Pro!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> pmapper-users mailing list
> [email protected]
> <mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
