[mapguide-users] SetSelectionXML on layer from database (PostgreSQL->PostgGIS)

[Kenneth, GEOGRAF A/S]

There may be (another) bug in the OGR provider.
As I recal, you cannot have mixed queries (spatial and attribute), but 
only one kind at a time.
Does that explain it?


Regards, Kenneth, GEOGRAF A/S



Maciej Skorczewski skrev:
> Hi
>
> I try make SetSelectionXML method on my layer who come from PostGIS 
> (PostgreSQL database).
>
> I make it whit SHP and all works fine...i get corect xml of selected 
> polygon...after call it MG make selection...
>
>
> BUT.
>
> When i try this whit layer who are in PostGIS i get bad xml (it is not 
> completed)
>
>
> this xml come from SHP file:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <FeatureSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
> xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd">
> <Layer id="5b908772-0000-1000-8002-0019d10e3e0f">
> <Class id="SHP_Schema:RoadCenterLines">
> <ID>DgEAAA==</ID></Class></Layer></FeatureSet>
>
>
> this xml come from PostGIS.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <FeatureSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
> xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd">
> </FeatureSet>
>
>
>
> what is wrong whit that?
>
> take a look on my code.
>
>
> ------- php code begin----------------
>
> MgInitializeWebTier ($configFilePath);
> $userInfo = new MgUserInformation($mgSessionId);
> $siteConnection = new MgSiteConnection();
> $siteConnection->Open($userInfo);
>
> $resourceService=$siteConnection->CreateService(MgServiceType::ResourceService); 
>
> $featureService=$siteConnection->CreateService(MgServiceType::FeatureService); 
>
>                        
>
>
> $map = new MgMap();
> $map->Open($resourceService, 'budynek2_db');
> $pomQuery = new MgFeatureQueryOptions();
> $pomQuery->SetFilter("Ogc_fid = '".trim($key)."'");
>
> //i get db connection to postgis
> //normaly it should be shp source
>
> $pomResId = new 
> MgResourceIdentifier("Library://budynek2/db_postgres/db.FeatureSource");
>
> //this is my layer       
> $featureReader = $featureService->SelectFeatures($pomResId, 
> "SDF_2_Schema:0x_poziom_0", $pomQuery);
>
> $layer = $map->GetLayers()->GetItem('0x_poziom_0');
> $selection = new MgSelection($map);
> $selection->AddFeatures($layer, $featureReader, 0);
> $selectionXml = $selection->ToXml();
>
> echo "<script type='text/javascript'>\n function OnPageLoad() {\n";
> echo "selectionXml = '$selectionXml';\n 
> parent.SetSelectionXML(selectionXml);\n";
> echo "$selectionXml";   
> echo "}\n</script>";
>                                 
>                                 
>
> ------- php code end----------------                           
>                     
>
> Maciej Skórczewski           
>     
>     
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users