Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions

2013-11-28 Thread Armin Burger
Wildcard searches as you can see in the debug logs are using ILIKE function, this however will not work on numeric fields. Just insert the query in a standard DB client and you will get errors. On 11/28/2013 04:36 PM, i...@architekten.coop wrote: > thank you chris, > > i missed to mention the e

Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions

2013-11-28 Thread info
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)),

Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions

2013-11-28 Thread 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, wrote: > dear pmapper users > > i have a table with field "raumnr" (numeric 3,2 unique) and field "gid" > (integer as primary key). > in the m

[pmapper-users] search with numeric field of postgis table and wildcard 1 not functions

2013-11-28 Thread info
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: if i use for the search the sign * to show all datas, this search does not functio

[pmapper-users] redraw a layer

2013-11-28 Thread gioza
is it possible to redraw/refresh a layer in pmapper5? for example: if I add new points to a point layer using mysql digitizing directly in my webgis, is it possible to refresh the map so that the point layer reappear with new points I have added? -- View this message in context: http://pmappe

Re: [pmapper-users] pmapper5 demo working 50%

2013-11-28 Thread Serge Claudio Rafanoharana
Dear Pillograsso and All, It seems that version 5 is working great on Linux system, but not on Windows yet. My config: - Windows 7, ms4w 3.0.6 - Apache 2.2.22 (with OpenSSL 0.9.8t) - PHP 5.4.3 - GDAL 1.9.1 - MapServer CGI 6.0.3 at /cgi-bin/mapser

Re: [pmapper-users] pmapper little bugs

2013-11-28 Thread Chris forum
On Fri, Jul 26, 2013 at 10:43 AM, Armin Burger wrote: > > 3) > > As Pedro said some days earlier, an '@' in an attribute value is replaced > > by an 'Email' in the result of a query. > > It happens on my project with two shapefile layers. > > I already tried to understand why this happens but I c