<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:p =
"urn:schemas-microsoft-com:office:powerpoint" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s =
"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs =
"urn:schemas-microsoft-com:rowset" xmlns:z = "#RowsetSchema" xmlns:b =
"urn:schemas-microsoft-com:office:publisher" xmlns:ss =
"urn:schemas-microsoft-com:office:spreadsheet" xmlns:c =
"urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa =
"urn:schemas-microsoft-com:office:activation" xmlns:html =
"http://www.w3.org/TR/REC-html40" xmlns:q =
"http://schemas.xmlsoap.org/soap/envelope/" XMLNS:D = "DAV:" xmlns:x2 =
"http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois =
"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir =
"http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds =
"http://www.w3.org/2000/09/xmldsig#" xmlns:dsp =
"http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc =
"http://schemas.microsoft.com/data/udc" xmlns:xsd =
"http://www.w3.org/2001/XMLSchema" xmlns:sps =
"http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi =
"http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf =
"http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf =
"http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver =
"http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels =
"http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t =
"http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m =
"http://schemas.microsoft.com/exchange/services/2006/messages"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-7">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.emailstyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-name: emailstyle17
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=054412921-02012008><FONT face=Arial
color=#0000ff size=2>I don't believe you can do that two step process with
MapServer queries. The only way you could do that is if you where using
PostGIS, Oracle Spatial or SDE where all your data was stored in the same
database. You can however join a .dbf file to your shapefile on the fly
and access those fields, but that is about as close as you can
get.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=054412921-02012008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=054412921-02012008><FONT face=Arial
color=#0000ff size=2>Maybe someone else knows a another method I am not thinking
about to accomplish that same thing.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>Brian Fischer</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Houston Engineering, Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Maple Grove, MN</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>(763) 493-4522</FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Adam Feidt [mailto:afeidt@edenprairie.org]
<BR><B>Sent:</B> Wednesday, January 02, 2008 3:27 PM<BR><B>To:</B> Fischer,
Brian<BR><B>Subject:</B> RE: [Geomoose-users] Database
connections<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">I was essentially trying to
mimic the identify tool using a FILTER and TEMPLATE. I thought I could
just point to a table by setting the CONNECTION and CONNECTIONTYPE layer
parameters in the mapfile. I guess I was way off. I want to be able
to click on a parcel/grab the PID from the shapefile and display property info
from a SQL database. I’ll play around with what you just gave me and see
if I can get it to work. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Adam M.
Feidt<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">GIS
Coordinator<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">City of Eden
Prairie<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">8080 Mitchell
Rd<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Eden Prairie, MN
55344<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">phone#
952-949-8443<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">fax#
952-949-8334<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Fischer, Brian
[mailto:bfischer@houstonengineeringinc.com] <BR><B>Sent:</B> Wednesday, January
02, 2008 3:09 PM<BR><B>To:</B> Adam Feidt;
geomoose-users@lists.sourceforge.net<BR><B>Subject:</B> RE: [Geomoose-users]
Database connections<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">Adam,</SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">Another
question is what server side language are you trying to use to query the MSSQL
database? You can not query a DB directly with javascript. Attached
is a PHP script to connect to an MS Access database, query it and write out
the results as HTML. This script is the one that does the address search
on <A
href="http://mmcd.mapmorph.net/mmcd/mmcd.html">http://mmcd.mapmorph.net/mmcd/mmcd.html</A> GeoMOOSE
app. Also below is the mapbook definition for the service to return the
results to the info tab. And lastly the HTML DIV that is used to display
the search options.</SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">XML
snippet:</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'"><service
title="Zoom To Address" selectable="false" default="false" locked="true"
div="addresssearch"><BR> <url>/mmcd/addresssearch.php</url><BR> <input
type="user" name="searchval" title="Zoom to
Address:"/><BR> </service></SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">HTML
snippet:</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'"><div
id="CustomForms"><BR> <div
id="addresssearch"><BR> <font color="black"><b>Zoom to
Address:</b></font><br/><BR> <input
name="searchval"/><input type="submit"
value="Go"/><BR> <br><i>Street address (no city or
zip) or portion of
address<i/><BR> </div></SPAN><o:p></o:p></P>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'"> <div
id="waitingmessage"><BR> <font
color="red"><b>Searching...</b></font><br/><BR> </div><BR></div></SPAN><o:p></o:p></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">Hopefully
this gives you an example of a search service using PHP and
an external database with GeoMOOSE.<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'"><BR> </SPAN><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Brian
Fischer</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Houston Engineering,
Inc.</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Maple Grove,
MN</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">(763)
493-4522</SPAN><o:p></o:p></P>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
geomoose-users-bounces@lists.sourceforge.net
[mailto:geomoose-users-bounces@lists.sourceforge.net] <B>On Behalf Of </B>Dan
Little<BR><B>Sent:</B> Wednesday, January 02, 2008 2:50 PM<BR><B>To:</B> Adam
Feidt; geomoose-users@lists.sourceforge.net<BR><B>Subject:</B> Re:
[Geomoose-users] Database connections</SPAN><o:p></o:p></P>
<DIV>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Adam,<BR><BR>Do you
have any sort of script that already connects to and searches the MSSQL
database?<o:p></o:p></SPAN></P>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt">----- Original Message
----<BR>From: Adam Feidt <afeidt@edenprairie.org><BR>To:
geomoose-users@lists.sourceforge.net<BR>Sent: Wednesday, January 2, 2008 2:44:40
PM<BR>Subject: [Geomoose-users] Database connections<SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p></o:p></SPAN></P>
<DIV>
<P class=MsoNormal>I assume this can be done after looking at other applications
created by Geomoose, but what I<SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">¢</SPAN>m trying to do is make a
non-spatial database connection to SQL server. Ideally my tool will grab
the PID and connect to a database and display table values in the info
tab. It doesn<SPAN style="FONT-FAMILY: 'Arial','sans-serif'">¢</SPAN>t
appear to be too complicated, but I<SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">¢</SPAN>m having problems setting up a
connection. I<SPAN style="FONT-FAMILY: 'Arial','sans-serif'">¢</SPAN>ve
read articles on ODBC/OVF/OGR is this the correct method? Can someone
point me in the right direction for setting up a SQL connection?<o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal>Adam M. Feidt<o:p></o:p></P>
<P class=MsoNormal>GIS Coordinator<o:p></o:p></P>
<P class=MsoNormal>City of Eden Prairie<o:p></o:p></P>
<P class=MsoNormal>8080 Mitchell Rd<o:p></o:p></P>
<P class=MsoNormal>Eden Prairie, MN 55344<o:p></o:p></P>
<P class=MsoNormal>phone# 952-949-8443<o:p></o:p></P>
<P class=MsoNormal>fax# 952-949-8334<o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P></DIV></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'">
<HR align=center width="100%" SIZE=1>
</SPAN></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'">Never miss a
thing. <A href="http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs">Make
Yahoo your homepage.</A> <o:p></o:p></SPAN></P></DIV></BODY></HTML>