<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18865">
<DIV><FONT size=2 face=Arial>Thx for info, I can select it now.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Now, another problem... </FONT></DIV>
<DIV><FONT size=2 face=Arial>I created the JOIN, restarted MGOS just in
case...</FONT></DIV>
<DIV><FONT size=2 face=Arial>In MG Studio I can edit the features, it lists the
feature values (means it reads data from the new join) but
the layer is empty (nothing shown on map).</FONT></DIV>
<DIV><FONT size=2 face=Arial>In FeatureSource editor in MG Studio I can preview
my other tables and views, but when I try to preview (data and features) my
JOIN I get an error...</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV>An exception occurred in FDO component. ORA-12520: TNS:listener could not
find available handler for requested type of server </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I am using MGOS 2.1 and King.Oracle version
0.8.8</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=0" target="_top" rel="nofollow">[hidden email]</a> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=1" target="_top" rel="nofollow">[hidden email]</a> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, January 25, 2010 2:19
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [mapguide-users] King.Oracle
provider - how to create join with table without geometry data?</DIV>
<DIV><BR></DIV>If I am not mistaken you can use KingFdoClass metadata table to
add non-geometry tables.
<DIV><BR></DIV>
<DIV>Haris<BR><BR>
<DIV class=gmail_quote>On Mon, Jan 25, 2010 at 2:10 PM, <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=2" target="_top" rel="nofollow">[hidden email]</a> <SPAN dir=ltr><<A href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=0" rel="nofollow" target=_top link="external">[hidden email]</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote><BR>Hi,<BR><BR>I have a data warehouse with a FACT table
containing a lot of points (GPS<BR>locations). And I have a DATE dimension
table.<BR>I want to draw a layer containing all locations within 1 day (or a
period of<BR>days).<BR><BR>I was thinking of doing a JOIN with King.Oracle
of that FACT and DIMENSION<BR>table, exporting it to XML and then in PHP
editing the filter tag with "DATE<BR>= YYYY.MM.DD". After modifying the
layer, I would insert the new layer into<BR>map and draw it.<BR>It should
also work fast enough for users to be able to go BACK and
FORWARD<BR>displaying maps for each day.<BR><BR>The problem is, in
King.Oracle provider, I see only tables and views with<BR>geometry fields.
And I need to join my DATE dimension which has no
geometry<BR>(logicaly).<BR>Is it possible?<BR><BR>Also, has anyone a better
solution for my problem?<BR><BR>I have round 10 Mil GPS locations for every
year.<BR><BR>Thx!<BR><FONT color=#888888>--<BR>View this message in context:
<A href="http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html" rel="nofollow" target=_blank link="external">http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html</A><BR>Sent
from the MapGuide Users mailing list archive at
Nabble.com.<BR>_______________________________________________<BR>mapguide-users
mailing list<BR><A href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=1" rel="nofollow" target=_top link="external">[hidden email]</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="nofollow" target=_blank link="external">http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></FONT></BLOCKQUOTE></DIV><BR></DIV><BR>_______________________________________________
<BR>mapguide-users mailing list <BR><A href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=2" rel="nofollow" target=_top link="external">[hidden email]</A> <BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="nofollow" target=_top link="external">http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></BLOCKQUOTE>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4454203.html">Re: [mapguide-users] King.Oracle provider - how to create join with table without geometry data?</a><br>
Sent from the <a href="http://n2.nabble.com/MapGuide-Users-f1803227.html">MapGuide Users mailing list archive</a> at Nabble.com.<br>