<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD><TITLE>[mapguide-users] Shapefile Query don't return all results</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=076270814-02052007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=076270814-02052007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=076270814-02052007><FONT face=Arial
color=#0000ff size=2>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=076270814-02052007><FONT face=Arial
color=#0000ff size=2>Dave</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Jason
Birch<BR><B>Sent:</B> Tuesday, May 01, 2007 9:57 PM<BR><B>To:</B> MapGuide Users
Mail List<BR><B>Subject:</B> RE: [mapguide-users] Shapefile Query don't return
all results<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText42531 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Normand,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>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?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Jason</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV id=idSignature80827 dir=ltr>
<DIV><FONT color=#000000 size=2><FONT size=2>
<DIV></FONT></FONT>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Normand Savard<BR><B>Subject:</B>
[mapguide-users] Shapefile Query don't return all results<BR></FONT><BR><FONT
size=2>I also tested with the following query "(MUNICIPALI
LIKE<BR>'$szMunicipality') AND (NOM LIKE '$szStreet') " and it returns only
one<BR>result but it should return two
results.<BR></FONT></DIV></DIV></DIV></BODY></HTML>