[mapserver-users] query case insensitive

[Steve Lime]

Use the *~ operator as described at:

  http://www.postgresql.org/docs/8.3/static/functions-matching.html

Steve

>>> "Sven Schroeter" <schroeter at netgis.de> 09/24/08 5:12 AM >>>
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 


_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users