<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 70.85pt 70.85pt 70.85pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.E-mailStijl17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=NL vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>Hi Fons,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>I have only implemented the functionality with PostGIS
recently, but I do believe it should work the way you are using
it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>There were some issues with Mapserver queries to
PostGIS and quotes in version 4.10, but I have put a fix in for that last
week (additional quotes around query). On my end, I can do a query on a string
attribute without problems (partial match also works, e.g. 'OLO00' in your
case). But my data statements are very simple. There have been several messages
lately about quotes, and things that don't work like before, so perhaps it
is related somehow..... Try putting quotes everywhere :)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>Make sure you have the latest version of the widget (>
25 Oct), because this is when I applied the quote fix.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>Try what Bart said (capturing the query), and let me know
what it says. By the way, do any queries work for you with this
widget?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2>regards,</FONT></SPAN></DIV><SPAN class=613001100-01112006>
<DIV dir=ltr align=left><BR><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=613001100-01112006>J</SPAN>acob</FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=613001100-01112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> chameleon-bounces@lists.maptools.org
[mailto:chameleon-bounces@lists.maptools.org] <B>On Behalf Of </B>Fons
Arts<BR><B>Sent:</B> 31 October 2006 23:08<BR><B>To:</B>
chameleon@lists.maptools.org<BR><B>Subject:</B> [Chameleon] LocateByAttribute
in Postgis<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi
list,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am added the latest widget (from
CVS) locatebyattribute to zoom to values stored in a Postgis
database.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">In this test I’m searching for the
value OLO00 A 1037 witch exist in a view. After clicking the search button I
get no results.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">Warning:
[MapServer Error]: msQueryByAttributes(): No matching record(s) found. in
E:\ms4w\chameleon\htdocs\widgets\LocateByAttribute\searchresults.phtml on line
361<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">No results
found for 'OLO00 A 1037'<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">--------------------------------------------------------------------------------<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
kadastraal nummer aanduid Find
<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">Limit search
to current map extents <o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">My Map file looks
like;<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<I><SPAN
style="FONT-STYLE: italic">LAYER<o:p></o:p></SPAN></I></SPAN></FONT></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
CONNECTIONTYPE postgis<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
NAME "kadastraal nummer"<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
GROUP "Eigendommen"<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
CONNECTION
*************************************************************<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
DATA "wkb_geometry from (select oid, aanduid, eigenaar, wkb_geometry from
public.v_kadaster where aanduid = 'OLO00 A 1037') as foo using srid=-1 using
unique aanduid"<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
TEMPLATE "dummy.htm"<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
TOLERANCE
10<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
MINSCALE 0<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
MAXSCALE 20000<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
STATUS default<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
TYPE
polygon<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
METADATA <o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
SPATIALSEARCH "aanduid"<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
END<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
CLASS<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
NAME 'string'<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
SIZE 22<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
COLOR 253 239 221 <o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
outlineCOLOR 255 255 0 <o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
MINSCALE 0<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
END<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
END <o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
END #
LAYER<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></I></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Anybody
tips<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Fons<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>