PHP mapscript : Can't use queryByIndex result

[fabien-cat]

Hello,

I can't use queryByIndex result on Postgis layers (Mapserver 6.4.1, PHP 5.5.12, Postgis 2.0).
$iIndexLayer=1;
$aQueryIndex=new array(2211, 2215);
foreach($aQueryIndex as $iIndex){
$oLayer=$oMap->getLayer($iIndexLayer);
$oLayer->queryByIndex(-1,$iIndex,MS_TRUE);
}

    $oLayer=$oMap->getLayer($iIndexLayer);
    echo $oLayer->getNumResults();  // return 2, it's OK

     for ($i=0; $i<$oLayer->getNumResults(); $i++){
        $oShape=$oLayer->getShape($oLayer->getResult($i));
        echo $oShape->index; // return always 2215, the last one
    }

I've a second problem if I do :
$sMapFile="my_mapfile.map.qy";
$oMap->savequery($sMapFile);
$oMap->loadQuery($sMapFile);

    $oLayer=$oMap->getLayer($iIndexLayer);
    echo $oLayer->getNumResults();  // return 3 instead of 2

If I do a savequery(), the getNumResults() is always increases 1.

I see that issue :
#4076
Indeed, the getNumresults() function works but the result can't be use.

In version 5.4 of Mapserver everything works fine.

I looked the code (mapquery.c), this is complex, maybe there is a problem with the result index ?!

Thanks,

Fabien Marty

[mkofahl]

Thank you, @fabien-cat. With postgis, the result index is always 0, which is the row number. See #4932 for further explanation.

[fabien-cat]

Thanks @mkofahl , so why there's a good number result but always the same index for Shapes result ?
There's a problem with the function msQueryByIndex() or addResult() ?

[mapserver-bot]

This is an automated comment

This issue has been closed due to lack of activity. This doesn't mean the issue is invalid, it simply got no attention within the last year. Please reopen with missing/relevant information if still valid.

Typically, issues fall in this state for one of the following reasons:

• Hard, impossible or not enough information to reproduce
• Missing test case
• Lack of a champion with interest and/or funding to address the issue