[mapserver-users] query case insensitive

Sven Schroeter schroeter at netgis.de
Wed Sep 24 06:11:00 EDT 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