<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>isset - checks to see if the value has been set from the CGI call. It's a damned goofy PHP thing. The != "" means "not an empty string."</span></div><div><br><span></span></div><div><span>But you still need the wildcards for partial matching with like. If you're looking for exact matches than use "=" in the SQL.</span></div><div><br><span></span></div><div><span>And JimK, your suspicion is correct, MapServer filters doesn't allow for bind values without my patches for it (which may or may not be in the 6.0 code, I need to check again, same with table checking code).</span></div><div><br><span></span></div><div><span>EliA, I believe JimD is using a substantially older version of GeoMOOSE with a custom PHP service. <br></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255);
margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Jim Dahl <jim.dahl@mail.co.douglas.mn.us><br> <b><span style="font-weight: bold;">To:</span></b> Dan Little <danlittle@yahoo.com>; "geomoose-users@lists.osgeo.org" <geomoose-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, May 23, 2012 12:53 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: [Geomoose-users] GeoMoose Search on Multi Fields with Implode Clause<br> </font> </div> <br>
<div id="yiv1825352159">
<style><!--
#yiv1825352159
_filtered #yiv1825352159 {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv1825352159 {font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv1825352159
#yiv1825352159 p.yiv1825352159MsoNormal, #yiv1825352159 li.yiv1825352159MsoNormal, #yiv1825352159 div.yiv1825352159MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
#yiv1825352159 a:link, #yiv1825352159 span.yiv1825352159MsoHyperlink
{
color:blue;
text-decoration:underline;}
#yiv1825352159 a:visited, #yiv1825352159 span.yiv1825352159MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
#yiv1825352159 p.yiv1825352159MsoAcetate, #yiv1825352159 li.yiv1825352159MsoAcetate, #yiv1825352159 div.yiv1825352159MsoAcetate
{
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"sans-serif";}
#yiv1825352159 p.yiv1825352159msonormal, #yiv1825352159 li.yiv1825352159msonormal, #yiv1825352159 div.yiv1825352159msonormal
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
#yiv1825352159 p.yiv1825352159msochpdefault, #yiv1825352159 li.yiv1825352159msochpdefault, #yiv1825352159 div.yiv1825352159msochpdefault
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
#yiv1825352159 span.yiv1825352159msohyperlink
{}
#yiv1825352159 span.yiv1825352159msohyperlinkfollowed
{}
#yiv1825352159 span.yiv1825352159emailstyle17
{}
#yiv1825352159 p.yiv1825352159msonormal1, #yiv1825352159 li.yiv1825352159msonormal1, #yiv1825352159 div.yiv1825352159msonormal1
{
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"sans-serif";}
#yiv1825352159 span.yiv1825352159msohyperlink1
{
color:blue;
text-decoration:underline;}
#yiv1825352159 span.yiv1825352159msohyperlinkfollowed1
{
color:purple;
text-decoration:underline;}
#yiv1825352159 span.yiv1825352159emailstyle171
{
font-family:"sans-serif";
color:windowtext;}
#yiv1825352159 p.yiv1825352159msochpdefault1, #yiv1825352159 li.yiv1825352159msochpdefault1, #yiv1825352159 div.yiv1825352159msochpdefault1
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"sans-serif";}
#yiv1825352159 span.yiv1825352159EmailStyle27
{
font-family:"sans-serif";
color:#1F497D;}
#yiv1825352159 span.yiv1825352159BalloonTextChar
{
font-family:"sans-serif";}
#yiv1825352159 .yiv1825352159MsoChpDefault
{
font-size:10.0pt;}
_filtered #yiv1825352159 {
margin:1.0in 1.0in 1.0in 1.0in;}
#yiv1825352159 div.yiv1825352159WordSection1
{}
--></style>
<div>
<div class="yiv1825352159WordSection1">
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Dan, I am not sure what the isset does and the != “” must be saying to ignore the field if there are no entries? Anyway, I get no results on any searches</span></div>
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">if($field3 == "HNUM" and isset($searchval3) and $searchval3 != "") {</span></div>
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">array_push($clauses, "HNUM like '".$searchval3."'");</span></div>
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">}</span></div>
<div class="yiv1825352159MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;">
<div class="yiv1825352159MsoNormal"><b><span style="font-size:10.0pt;">From:</span></b><span style="font-size:10.0pt;"> Dan Little [mailto:danlittle@yahoo.com]
<br>
<b>Sent:</b> Wednesday, May 23, 2012 12:15 PM<br>
<b>To:</b> Jim Dahl; geomoose-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [Geomoose-users] GeoMoose Search on Multi Fields with Implode Clause</span></div>
</div>
</div>
<div class="yiv1825352159MsoNormal"> </div>
<div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;">Wouldn't it be easier to simply check if a value is set?</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;">IE:</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;">if($field3 == "HOUSE" and isset($searval3) and $searchval3 != "") {</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;"> ... add the clause</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;">}</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;">That way you don't have an extra SQL bits. The extraneous "OR"s would just serve to confuse the database.</span></div>
</div>
<div>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:3.75pt;margin-bottom:5.0pt;">
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="font-size:10.0pt;color:black;"> </span></div>
<div>
<div>
<div>
<div class="yiv1825352159MsoNormal" style="text-align:center;background:white;" align="center">
<span style="font-size:10.0pt;color:black;">
<hr align="center" size="1" width="100%">
</span></div>
<div class="yiv1825352159MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">From:</span></b><span style="font-size:10.0pt;color:black;"> Jim Dahl <<a rel="nofollow" ymailto="mailto:jim.dahl@mail.co.douglas.mn.us" target="_blank" href="mailto:jim.dahl@mail.co.douglas.mn.us">jim.dahl@mail.co.douglas.mn.us</a>><br>
<b>To:</b> "<a rel="nofollow" ymailto="mailto:geomoose-users@lists.osgeo.org" target="_blank" href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a>" <<a rel="nofollow" ymailto="mailto:geomoose-users@lists.osgeo.org" target="_blank" href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a>>
<br>
<b>Sent:</b> Wednesday, May 23, 2012 8:40 AM<br>
<b>Subject:</b> [Geomoose-users] GeoMoose Search on Multi Fields with Implode Clause</span><span style="color:black;"></span></div>
</div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
<div id="yiv1825352159">
<div>
<div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">I have need to search on multiple fields and the following code works if I have a wildcard in all of the fields. If I take out a wildcard and do not enter anything in that field, the result
is nothing found. Probably because the empty field doesn’t match the database for any entries. So what I would like to do is Make and OR with the field without a wild card and the other fields that have the AND. Hope this makes sense to someone. I credit
Dan with the code for the implode clauses and it works great with the criteria of wild cards or have a pull down in the field that contains all the possible entries. HNUM is the field I would like to not have the wildcard. I have as many as ten fields, but
show fewer for this example. THANKS.</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">$clauses = array();</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">if($field3 == "HNUM") {</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">array_push($clauses, "HNUM like '".$searchval3."'");</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">}</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">if($field4 == "STREET") {</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">array_push($clauses, "STREET like '%".$searchval4."%'");</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">}</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">if($field5 == "CITY") {</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">array_push($clauses, "CITY like '%".$searchval5."%'");</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">}</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">$all_clauses = implode(" AND ", $clauses);</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">$rs = $conn->Execute("SELECT * FROM housenum WHERE ".$all_clauses." ORDER BY ".$sort." ASC");</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">Jim Dahl, GISP</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">GIS Coordinator</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">Douglas County Public Works</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">526 Willow Dr</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">PO Box 398</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">Alexandria MN 56308</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">V 320-762-2933</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> 320-762-2999</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;">F 320-762-2998</span></div>
</div>
<div>
<div class="yiv1825352159MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
<div class="yiv1825352159MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="color:black;"><br>
_______________________________________________<br>
Geomoose-users mailing list<br>
<a rel="nofollow" ymailto="mailto:Geomoose-users@lists.osgeo.org" target="_blank" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
http://lists.osgeo.org/mailman/listinfo/geomoose-users<br>
<br>
</span></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div><br><br> </div> </div> </blockquote></div> </div></body></html>