<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:CourierNewPSMT;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
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","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Max,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The exception message resulting from line 403 of mapguidecommon/Services/ProxyGwsFeatureReader.cpp
tells me that the filter value is expecting an integer type, and you have
actually passed it a double. Try modifying your script so that the line
that reads $n=$name+0.0 is changed to $n=$name.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ronnie<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rahul
[mailto:unicorn_admirer@yahoo.com] <br>
<b>Sent:</b> Thursday, September 06, 2007 9:18 PM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> RE: [mapguide-users] SDF & SQL Server 2005 Joined Feature
Source<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Hi Ronnie,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>
Thanks for your kind reply,Actually first i tried to work with SQL Server 2005
and storing Geometry data using Map3D2008 and i manage to create datastore and
edit,delete update etc from Map3D 2008 then i tried to use it for the web and
tried to theme and modify using the ADSK Mapguide studio 2008 but here the
problem start arising and i unable to get the properties and other things in
the mapguide studio although i able to manage connection ang get new feature
classes etc but unable to view and when i try to change some themeing condition
it use to give error that some table doesn not exists although i can easily
work with map3D 2008 with the same table,so then i tried to work with SDF and
joined the SDF file with SQL server2005 Views and i tried to query
but as you told that it will filter only on primary source of join so i tried
to set filter on the primary source of the joined feature source,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>$name = trim($_GET['sDeed']);<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <br>
if (strlen($name) > 0 )<br>
{<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <br>
$n=$name+0.0; <br>
<br>
echo gettype($n);---------------------->Double<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> $filter="ID=".$n; <br>
<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> $featureResId = new
MgResourceIdentifier("Library://ABC/Data/Estates.FeatureSource");<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><br>
$queryOptions = new MgFeatureQueryOptions();<br>
$queryOptions->SetFilter($filter);<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>This use to give the following error in the joined feature
source with filter on primary source-<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='color:#BF005F'>Double</span><o:p></o:p></p>
</div>
<div>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%'>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='color:#BF005F'>ID=1The Property Type is
invalid.The Property Type is invalid. Exception occurred in method
MgProxyGwsFeatureReader.GetProperty at line 403 in file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\common\mapguidecommon\Services/ProxyGwsFeatureReader.cpp</span>
<o:p></o:p></p>
</td>
</tr>
</table>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>but when i use the same filter on the SDF File(not
Joined) it use to give me the result ,so can you tell me what i am missing
or doing wrong and how can i proceed with working SQL Server 2005 and Autodesk
MapGuide Studio 2008.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thanks<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Max<br>
<br>
<b><i>Ronnie Louie <ronnie.louie@autodesk.com></i></b> wrote:<o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Max,<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>When you have join of SDF to SQL Server feature source, you can
only define a filter for the fields from the primary source of the join (i.e.
the properties in the SDF). It is not currently possible to setup a filter
for the secondary feature source of a join (i.e. the SQL Server datasource
properties). Depending on what you a trying to achieve, you may be able
to get similar desired result by setting up an appropriate theme based on the
properties from the secondary feature source.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ronnie<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rahul
[mailto:unicorn_admirer@yahoo.com] <br>
<b>Sent:</b> Thursday, September 06, 2007 3:27 AM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> [mapguide-users] SDF & SQL Server 2005 Joined Feature
Source<o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<p class=MsoNormal>Hi All,<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal> I
tried to join the SDF faeture source spatial data with the SQL Server 2005
Views(non spatial data) ,I manage to get the new joined feature source and
get the attributes in the property pane but i stuck in the Search
criteria and when i tried to search the joined feature class using the
filter like -<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal>$filter ="LU_STATUS = '" . $status
."'"." and " . "PD_GROUP=
'".$group."'"." and " . "SHAREHOLDE=
'".$share."'"." or " . "PROMOTION=
'".$plan."'";<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'>$queryOptions
= new MgFeatureQueryOptions();<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'>$queryOptions->SetFilter($filter);<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:CourierNewPSMT'>I unable to get any
values and it use to give no search found.Can anybody help me regarding this
issue and where i can get some detail for working with SQL commands on
the feature source ,i tried in the mapagent some basic sql commands but it use
to give error and i cannot find the way to go with them.</span><span
style='font-size:7.5pt;font-family:CourierNewPSMT'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'>Thanks<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:CourierNewPSMT'>Max<o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<div>
<p class=MsoNormal>Yahoo! oneSearch: Finally, <a
href="http://us.rd.yahoo.com/evt=48252/*http:/mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC">mobile
search that gives answers</a>, not web links. <o:p></o:p></p>
</div>
<p class=MsoNormal>_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users<o:p></o:p></p>
</blockquote>
<p class=MsoNormal><o:p> </o:p></p>
<p> <o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p class=MsoNormal>Moody friends. Drama queens. Your life? Nope! - their life,
your story.<br>
<a href="http://us.rd.yahoo.com/evt=48224/*http:/sims.yahoo.com/">Play Sims
Stories at Yahoo! Games. </a><o:p></o:p></p>
</div>
</body>
</html>