[mapguide-users] ExecuteSqlQuery Not Working

[flakesns]

I use MgFeatureQueryOptions  now. The question how to select distinct the
property value from the dbf file?

$queryOptions = new MgFeatureQueryOptions();
    
    $queryOptions->AddFeatureProperty("CATEGORY");
    //$queryOptions->SetFilter($sql); // HOW TO SELECT DISTINCT/UNIQUE
VALUE????????

    $featureReader = $featureService->SelectFeatures($layerFeatureResource,
$featClassName, $queryOptions);
    
    while ($featureReader->ReadNext())
    {
       echo '<br>'.$category = $featureReader->GetString('CATEGORY');
    }




Jackie Ng wrote:
> 
> The SHP provider does not support SQL commands. 
> 
> You have to use MgFeatureQueryOptions to do your queries.
> 
> - Jackie
> 
> 
> flakesns wrote:
>> 
>> I got problem here.
>> 
>> here is my code (php):
>> 
>> $layerFeatureResource = new MgResourceIdentifier($layerFeatureId);
>> 
>> $sql = "select road_name from roadTable where featId = 2";
>> $sqlDataReader = $featureService->ExecuteSqlQuery($layerFeatureResource,
>> $sql);
>> 
>> It's return me : 
>> 
>> "The requested operation is invalid.
>> 
>> The requested operation is invalid. Exception occurred in method
>> MgServerSqlCommand."
>> 
>> I use connection to shp folder and data store in dbf file.
>> 
>> Whats the problem exactly?
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/ExecuteSqlQuery-Not-Working-tp2472312p2483908.html
Sent from the MapGuide Users mailing list archive at Nabble.com.