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 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, > > 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:
>>
>>  
>> 
>>   >  wildcard="1" />
>>   
>>
>>  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:
>>
>>  
>> 
>>   >  wildcard="1" />
>>   
>>
>>
>>  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
>>  pmapper-users@lists.sourceforge.net
>>  
>>  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
> pmapper-users@lists.sourceforge.net
> 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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

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)),
  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,  > 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:
>
> 
>
>   wildcard="1" />
>  
>   
> 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:
>
> 
>
>   wildcard="1" />
>  
>   
>
> 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
> pmapper-users@lists.sourceforge.net
> 
> 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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

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 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 function !
>
>
> if i take a string field, the search functions with wildcard 1 and *,
> the result table shows all fields:
>
> 
>
>   wildcard="1" />
>  
>   
>
> 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
> pmapper-users@lists.sourceforge.net
> 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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[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 function !


if i take a string field, the search functions with wildcard 1 and *,  
the result table shows all fields:


   
 
 
  

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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users