<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>Queries on values ending in ".0": 10 != 10.0</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi List,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Simple question: how come that in a mapserver query (php function queryByAttributes), the following does not hold true:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">2400=2400.0 (does not return a result. Only way to get this value is searching for 2400.0)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">In other words, if the value stored in the shapefile's DBF is 2400.0 (stored as a number with 1 decimal), searching for 2400 will not return that value. I guess you could say there is a difference of precision, but one could argue that the value is exactly the same.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Is there a way around this? I do not feel like using "string contains", because this gives undesirable results (for example, searching for "2" will return "2, 200, 232, 5562, etc).</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Regards,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Jacob</FONT>
</P>
<BR>
<P><B><FONT COLOR="#808080" SIZE=2 FACE="Verdana">Jacob Delfos </FONT><FONT COLOR="#3366FF" SIZE=2 FACE="Verdana">|</FONT></B><FONT COLOR="#808080" SIZE=2 FACE="Verdana"> GIS Analyst</FONT><BR>
<BR>
<B><FONT COLOR="#808080" SIZE=2 FACE="Verdana">Maunsell</FONT></B> <FONT COLOR="#808080" SIZE=2 FACE="Verdana">Australia New Zealand Asia</FONT><B><FONT COLOR="#808080" SIZE=2 FACE="Verdana"></FONT></B><BR>
<FONT COLOR="#808080" SIZE=1 FACE="Verdana">629 Newcastle St, Leederville, Western Australia 6007</FONT><FONT COLOR="#FF6600" SIZE=2 FACE="Verdana"></FONT><B></B><B> </B>
<BR><FONT COLOR="#808080" SIZE=2 FACE="Verdana">PO Box 81, Leederville, Western Australia 6902<BR>
</FONT><B><FONT COLOR="#3366FF" SIZE=2 FACE="Verdana">P</FONT><FONT COLOR="#FF8000" SIZE=2 FACE="Verdana"></FONT></B> <FONT COLOR="#808080" SIZE=2 FACE="Verdana">+61 8 9281 6185 </FONT><B><FONT COLOR="#3366FF" SIZE=2 FACE="Verdana">F</FONT></B><FONT COLOR="#808080" SIZE=2 FACE="Verdana"> +61 8 9281 6298 <BR>
</FONT><B><FONT COLOR="#3366FF" SIZE=2 FACE="Verdana">E</FONT></B><FONT COLOR="#FF8000" SIZE=2 FACE="Verdana"></FONT> <A HREF="mailto:jacob.delfos@maunsell.com"><FONT COLOR="#000080" SIZE=2 FACE="Verdana">jacob.delfos@maunsell.com</FONT></A><BR>
<A HREF="http://www.maunsell.com/"><U><FONT COLOR="#000080" SIZE=2 FACE="Verdana">www.maunsell.com</FONT></U></A>
</P>
</BODY>
</HTML>
<table><tr><td bgcolor=#ffffff><font color=#000000>This email and any attachments are intended solely for the named recipient and are confidential. The copying or distribution of them or any information they contain by anyone other than the named recipient is prohibited. If you have received this document in error, please notify the sender and delete all copies from your computer system and destroy all hard copies. It is the recipient's responsibility to check this email and any attachments to this email for viruses before use.<br>
</font></td></tr></table>