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, <i...@architekten.coop >> <mailto:i...@architekten.coop>> 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 >> pmapper-users@lists.sourceforge.net >> <mailto: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
