Search the mailing list: I think it has already been explained here
(just a zip to add to your current MS4W or something like that).
Le 03/01/2014 12:23, harpinder singh a écrit :
> 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
>
>
>
> 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=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>
--
Thomas RAFFIN
Chef de Projet Internet
traf...@sirap.fr <mailto:traf...@sirap.fr> Sirap <http://sirap.fr>
Tel
: 04 75 72 84 10
Fax : 04 75 70 07 98
Rue Paul Louis Héroult - BP 253
26106 Romans cedex
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
