[mapguide-users] Shapefile Query don't return all results

[Dave Wilson]

Normally in a sql query when doing a LIKE you would add a wildcard in
the expression Name LIKE 'John*'. I don't see any wildcards in your
expressions and as a result you usually end up with results matching an
equal comparison. Things like this often point out trailing spaces or
unprintable characters and things that aren't obvious in the data.
 
Regards,
Dave

  _____  

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Tuesday, May 01, 2007 9:57 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Shapefile Query don't return all results


Hi Normand,
 
Is it possible that this is an encoding issue?  For instance, are there
any French characters in the DBF file?  Or maybe there are embedded
spaces in the street or city name?
 
Jason
 
  _____  

From: Normand Savard
Subject: [mapguide-users] Shapefile Query don't return all results

I also tested with the following query "(MUNICIPALI LIKE
'$szMunicipality') AND (NOM LIKE '$szStreet') " and it returns only one
result but it should return two results.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070502/a41c2277/attachment.html