Re: [pmapper-users] query editor - text coloumns - no records selected - final
Brought to you by:
arminburger
Menu
▾
▴
Re: [pmapper-users] query editor - text coloumns - no records selected - final
|
From: harpinder s. <har...@re...> - 2014-01-03 11:23:54
|
Thanks for the reply,
I will try the new package, But please let me know how to upgrade my ms4w with the latest
pmapper, pmapper-dev.zip.
Also regarding the link you had sent, i have tried the modifications in the x_queryeditor.php
file but only two string options work: 'equal' and 'different' .
rest options 'start with', 'ends with', 'contain' and 'does not contain' do not work. any
solution.
part of the x_queryeditor.php is as follows:
// SHP :
if ($layerType == 1) {
$_REQUEST['layerType'] = 'shape';
$_REQUEST['firstFld'] = $firstFld;
$modifiedQueryTmp = preg_replace("/([^\[]*)\[([^\]]*)\]\s*([^\s]*)\s*'([^']*[^\\\])'/", "$1 \"
[$2]\" $3 '$4'", $modifiedQueryWithoutEOL);
$modifiedQueryTmp = str_replace(" LIKE ", " = ", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace(" ILIKE ", " =*", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace(" LIKE ", " =~ ", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace("/'%", "/", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace("%'/", "/", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace("/'", "/^", $modifiedQueryTmp);
$modifiedQueryTmp = str_replace("'/", "$/", $modifiedQueryTmp);
regards
harpinder
On Fri, 03 Jan 2014 15:08:56 +0530 wrote
>Hi,
As Thomas referred, you should try the last version of pmapper.
If you're not into it, you can have a look at this post
.
It might help you.
Regards.
Sylvain.
harpinder singh wrote
> Hello!
>
> I am using
>
> MapServer 4 Windows - version 3.0.6 on windows XP.
>
> pmapper 4.3.1 - BUILD 2013-04-04
>
> PHP 5.4.3
>
> MapServer CGI 6.0.3
>
>
>
> I am using shapefiles for my project. The problem is that when i query
> text columns in the
>
> query editor, no record are selected. But, when I use numeric field
> queryeditor is working
>
> fine.
>
>
>
> Log of numeric column giving no error:
>
>
>
> [03-Jan-2014 07:39:45] P.MAPPER debug info
>
> Parameters for REQUEST array
>
> file: query.php->q_execAttributeQuery
>
>
>
> Array
>
> (
>
> [operation] => query
>
> [layername] => mogavill
>
> [layerType] => shape
>
> [query] => [AREA] new
>
> [externalSearchDefinition] => 1
>
> [mode] => search
>
> [layerName] => mogavill
>
> [firstFld] => AREA
>
> [qStr] => (([AREA]q_execAttributeQuery
>
>
>
> Array
>
> (
>
> [operation] => query
>
> [layername] => mogavill
>
> [layerType] => shape
>
> [query] => [VILLAGE_NA] LIKE 'M%'
>
> [selectMethode] => new
>
> [externalSearchDefinition] => 1
>
> [mode] => search
>
> [layerName] => mogavill
>
> [firstFld] => VILLAGE_NA
>
> [qStr] => (( "[VILLAGE_NA]" = /^M/))
>
> )
>
>
>
> Kindly provide a solution as it is urgent. I think the problem is with the
> query string, but
>
> not able to solve it.
>
> ------------------------------------------------------------------------------
> 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=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@.sourceforge
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
View this message in context: http://pmapper-users-p-mapper-users-mailing-
list.993774.n3.nabble.com/pmapper-users-query-editor-text-coloumns-no-records-selected-final-
tp4025441p4025443.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.
------------------------------------------------------------------------------
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=84349831&iu=/4140/ostg.clktrk
_______________________________________________
pmapper-users mailing list
pma...@li...
https://lists.sourceforge.net/lists/listinfo/pmapper-users
|
