[mapserver-users] query case insensitive

Sven Schroeter schroeter at netgis.de
Wed Sep 24 03:11:00 PDT 2008


Hi all,

I'm using the queryByAttributes-function of PHP-Mapscript with the LIKE (~) 
operator for strings (out of a POSTGIS-table):

$queryString = "nom_bande ~ 'WT'";
$queryItem = "nom_bande";
@$datQuery = $layer->queryByAttributes($queryitem,$queryString,MS_MULTIPLE);

Every dataset that contains 'WT' comes as result. But this is case 
sensitive, if I try
$queryString = "nom_bande ~ 'wt'";
there is no result.

Is it possible to make the query case insensitive?

Thanks
Sven 





More information about the MapServer-users mailing list