<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[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]-->
<title>RE: [mapguide-users] RE: ODBC problem...</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
font-face
{font-family:Tahoma;}
font-face
{font-family:Verdana;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
p.codeline, li.codeline, div.codeline
{margin:.75pt;
font-size:10.0pt;
font-family:"Courier New";}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.emailstyle19
{font-family:Arial;
color:navy;}
span.emailstyle20
{font-family:Arial;
color:navy;}
span.code
{font-family:"Courier New";
font-weight:normal;
font-style:normal;}
span.filepath
{font-style:italic;}
span.EmailStyle26
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:884297094;
mso-list-template-ids:-492934356;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>That would be great, I will look forward
to it!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>-Brian<o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Kori Maleski
[mailto:km@pat.ca] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
7:36 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] PHP
-> .NET Active Selection</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText42636>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Brian,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I posted the second half of this solution in VB.NET here a
week or so ago.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I can repost tomorrow with more detail.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Cheers,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
<div id=idSignature89290>
<div>
<div>
<div style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><font size=3 color="#29537c" face="Times New Roman"><span
style='font-size:12.0pt;color:#29537C'> <o:p></o:p></span></font></p>
</div>
<div style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><strong><b><font size=3 color="#29537c"
face="Times New Roman"><span style='font-size:12.0pt;color:#29537C'>Kori
Maleski </span></font></b></strong><strong><b><font size=1 color="#29537c"
face="Trebuchet MS"><span style='font-size:7.5pt;font-family:"Trebuchet MS";
color:#29537C'>BSc</span></font><font color="#29537c"><span style='color:#29537C'>.
</span></font></b></strong><b><font color="#29537c"><span style='color:#29537C;
font-weight:bold'><br>
</span></font></b><strong><b><font size=1 color="#29537c" face="Times New Roman"><span
style='font-size:7.5pt;color:#29537C'>Senior Technical Consultant</span></font></b></strong><font
color="#29537c"><span style='color:#29537C'><o:p></o:p></span></font></p>
</div>
<div style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><font size=3 color="#29537c" face="Times New Roman"><span
style='font-size:12.0pt;color:#29537C'> </span></font><strong><b><font
face="Times New Roman"><o:p></o:p></font></b></strong></p>
</div>
<div style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><strong><b><font size=3 color="#29537c"
face="Times New Roman"><span style='font-size:12.0pt;color:#29537C'>Pacific <st1:City
w:st="on"><st1:place w:st="on"><u1:City u2:st="on"><u1:place u2:st="on">Alliance</st1:place></st1:City></u1:place></u1:City>
Technologies</span></font></b></strong><b><font color="#29537c"><span
style='color:#29537C;font-weight:bold'><br>
</span></font></b><font size=1 color="#29537c"><span style='font-size:7.5pt;
color:#29537C'>Suite 400 - 534 17 Ave. <st1:place w:st="on"><st1:City
w:st="on"><u3:place u4:st="on"><u3:City u4:st="on"><U4:PLACE u5:st="on"><u7:City u5:st="on">SW</u3:City></U4:PLACE></u3:City></u3:place> <u3:City u4:st="on">Calgary</st1:City></u3:City>, <st1:State
w:st="on"><u3:State u4:st="on"><u1:State u6:st="on">AB</u1:State></st1:State></u3:State>
<st1:country-region w:st="on"><u3:country-region u4:st="on"><u1:country-region u7:st="on">CANADA</u1:country-region></st1:country-region></u3:country-region>
<st1:PostalCode w:st="on"><u3:PostalCode u4:st="on"><u1:PostalCode u9:st="on">T2S
0B1</u1:PostalCode></st1:PostalCode></st1:place></span></u3:PostalCode></font><font
color="#29537c"><span style='color:#29537C'><br>
</span></font><font size=1 color="#ff823d" face="Trebuchet MS"><span
style='font-size:7.5pt;font-family:"Trebuchet MS";color:#FF823D'>TEL </span></font><font
size=1 color="#2a5973" face="Trebuchet MS"><span style='font-size:7.5pt;
font-family:"Trebuchet MS";color:#2A5973'>403.770.1917 </span></font><font
size=1 color="#ff823d" face="Trebuchet MS"><span style='font-size:7.5pt;
font-family:"Trebuchet MS";color:#FF823D'>FAX </span></font><font size=1
color="#2a5973" face="Trebuchet MS"><span style='font-size:7.5pt;font-family:
"Trebuchet MS";color:#2A5973'>877.691.9149 </span></font><font size=1
color="#ff823d" face="Trebuchet MS"><span style='font-size:7.5pt;font-family:
"Trebuchet MS";color:#FF823D'>TOL </span></font><font size=1 color="#2a5973"
face="Trebuchet MS"><span style='font-size:7.5pt;font-family:"Trebuchet MS";
color:#2A5973'>877.691.9171 </span></font><font color="#29537c"><span
style='color:#29537C'><a href="http://www.pat.ca/" title="http://www.pat.ca"><font
size=1 color="#ff823d"><span style='font-size:7.5pt;color:#FF823D'><span
title="http://www.pat.ca">www.pat.ca</span></span></font></a></span></font><o:p></o:p></p>
</div>
</div>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Berdel,
Brian [mailto:brian.berdel@mcmtrans.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wed 19/04/2006 2:09 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] PHP
-> .NET Active Selection</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>While I am able to work with the Active
Selection for the <st1:City w:st="on"><st1:place w:st="on">AJAX</st1:place></st1:City>
viewer in .NET, I am not able to come up with a solution for the DWG viewer in
NET. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The development sample using PHP says to:
Can anyone help me with a .NET solution to this? </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p><font size=2 color=black face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:black'>One method to do this is to create a
JavaScript function, then call this function from the Viewer using an Invoke
Script command. In an HTML page that includes an embedded Viewer, add the
following JavaScript function:</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>function listSelected()</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>{</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'> xmlSel =
ViewerFrame.mapFrame.GetSelectionXML(); </span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'> params = new
Array("SESSION", </span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'> ViewerFrame.mapFrame.GetSessionId(),
"SELECTION", xmlSel); </span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'> ViewerFrame.formFrame.Submit("../devguide/dwfselection.php",
</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'> params,
"taskPaneFrame");</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>}</span></font><o:p></o:p></p>
<p><font size=2 color=black face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:black'>In your web layout, create a new command and
add it to the task list. Set the command type to Invoke Script. Set the script
to invoke to </span></font><o:p></o:p></p>
<p><span class=code><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>parent.listSelected();</span></font></span><font
size=2 color=black face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
color:black'> </span></font><o:p></o:p></p>
<p><font size=2 color=black face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:black'>Create a page named </span></font><span
class=code><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt;color:black'>dwfselection.php</span></font></span><font size=2
color=black face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
color:black'> in the <span class=filepath><i>devguide</i></span> directory.
This can be exactly the same as <span class=charlink><a
href="file:///C:\Documents%20and%20Settings\bberdel\Desktop\MgOpenSourceDevGuide\WS1a9193826455f5ff9110c71085341391d-4846.html"><font
size=3><span style='font-size:12.0pt'>Example: Setting the Active Selection</span></font></a></span>,
with one modification. Replace the AJAX-specific code with the following:</span></font><o:p></o:p></p>
<p class=codeline><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>$selection = new MgSelection($map,
$_POST['SELECTION']);</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
4:06 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Property_joined is a standard query (not a
table) in my Access database. Yes, I have a parcel id (PID field) in
that query that matches the PID field in my SDF file. It does sound
like we are doing things the same way.</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>Andy
</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Butler,
Juan P [mailto:jpbutler@co.pinellas.fl.us] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
12:49 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Andy:</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>What’s the property_joined table you
have? I have a table that contains the parcel data with a column that
matches the SDF_ID. I’m assuming your property_joined
table is similar, correct? You didn’t do anything special to this
table, did you?</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Juan Butler - Senior Programmer/Analyst<br>
GIS Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
<a href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
3:01 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Here are some screenshots. I think
that will help clarify things.</span></font><o:p></o:p></p>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>Andy
</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Butler,
Juan P [mailto:jpbutler@co.pinellas.fl.us] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
11:40 AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I’m using the Access database as the
secondary and still not able to pull up the graphics connecting to the
secondary. In the Feature Data Setup for the layer, I go and choose
the Access database in the Feature Class dropdown. Is this not
correct? If I don’t do this, the Access fields won’t show
up. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Juan Butler - Senior Programmer/Analyst<br>
GIS Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
<a href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
2:06 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Thanks for the clarification Dave. I
hadn't even looked at my spatial datasource to notice that there is now a Join
portion of the dialog at that level. I was thinking the join was only
defined from the tabular datasource. Now that I have set it up there
(pretty much using the same steps I previously outlined) it is working
fine. I can display my parcel polygons with tooltips and properties
derived from the secondary Access database.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>It is a little confusing that it can be
done the other way around and that a layer can be seemingly created from that
while choosing the geometry feature from the secondary datasource. That
process should probably be changed in Studio to prevent that from happening.</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I'm still having problems with point data
from an ODBC resource, but will do some more experimenting later.</span></font><o:p></o:p></p>
</div>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>Andy
</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Dave
Wilson [mailto:dave.wilson@autodesk.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
7:26 AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Am I correct in understanding you are using
the spatial resource as the Secondary resource? The Spatial resource needs to
be the primary resource if this is what the layer is to be based on. The join
is generally for attaching attribute data to spatial data such as adding
properties from an Access table to an SDF.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Point data from an ODBC resource should
also work as a primary resource.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Dave Wilson</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy
Morsell [mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, April 18, 2006 6:22
PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Here
are the steps I took to create the join. Note that I wasn't able to do
with anything with the join in terms of creating a layer from it, however.</span></font><o:p></o:p></p>
<ul style='margin-top:0in' type=disc>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Once your datasource is setup
and you can see the tables listed in the Refine Data Setup area, click the
New Extended Feature Class button. </span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Choose your other datasource in
the repository that you are connecting to </span></font><o:p></o:p></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Choose the Primary Feature
class (table)</span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Click on your New Join below
the Extension you just created</span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>You will most likely only have
one option for the Secondary class (table)</span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Select your Primary Column and
Secondary Column fields. These are the key fields tying together
your primary (tabular) and secondary (spatial) datasources.</span></font> <o:p></o:p></li>
</ul>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>If
you get this far, please let us know if you can successfully create a layer
where you can view the resultant objects. I also tried creating a layer
from X and Y points in a table from this database and, again, was not able to
view the resultant geometry.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Andy
Morsell</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>-----Original
Message-----</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>From:
Thud732 [</span></font><a href="mailto:devlin.fung@sapience360.com"><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>mailto:devlin.fung@sapience360.com</span></font></a><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>] </span></font><br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sent:
Tuesday, April 18, 2006 4:30 PM</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>To: <st1:PersonName
w:st="on">users@mapguide.osgeo.org</st1:PersonName></span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Subject:
[mapguide-users] RE: ODBC problem...</span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi
Andy:</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Can
you please outline your 'join connection' steps? I was able to establish a
successful test connection, but failed when joining.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thank
you.</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>TC</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>--</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>View
this message in context: </span></font><a
href="http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-installation-t1432431.html#a3978903"><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-installation-t1432431.html#a3978903</span></font></a><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sent
from the OSGeo MapGuide forum at Nabble.com.</span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>---------------------------------------------------------------------</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>To
unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>For
additional commands, e-mail: users-help@mapguide.osgeo.org</span></font> <o:p></o:p></p>
</div>
</div>
</body>
</html>