[mapguide-users] ExecuteSqlQuery Not Working

[Jackie Ng]

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-tp2472312p2472374.html
Sent from the MapGuide Users mailing list archive at Nabble.com.