[mapguide-users] Concatenate geographic and non-geographic data

[Dave Wilson]

First of all I'm changing the thread name as this is completely unrelated to the previous heading.

There are 2 options that come to mind:


1)      Create views in your database. What is your database platform?

2)      Try to connect to your non-geographic tables using an ODBC connection assuming you have a driver that works with your database and you can figure out how to set the DSN or create a connection string that works. Once you have the ODBC connection working in MapGuide you can attempt to Join the OGR connection to the ODBC connection. I suspect this is going to cause you all kinds of grief depending your OS and the database platforms and whether or not the OGR provider supports joins...(I honestly don't know).

If you don't have a copy of MG Studio, I'm not sure how easy this is in Maestro.

Regards,
Dave

From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rui Daniro
Sent: Monday, March 09, 2009 11:32 AM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] Weblayouts Buil-in commands

Hi kenneth,

I have a OGR connection to my database. I can see my data with geographic attributes but I can not see the other tables with non geographic data. How can I acess them to use the data stored there? I would like to concanate tables with geographic data with table with non geographic data to display attributes stored in several tables. Can you help me with this?

Thanks

Rui

De: Kenneth Skovhede, GEOGRAF A/S (via Nabble) [mailto:ml-user+64672-1645459268 at ...<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2450420&i=0>]
Enviada: 25 February 2009 11:54
Para: Rui Daniro
Assunto: Re: [mapguide-users] Weblayouts Buil-in commands

That depends on what you mean by "edit/customize".
If you mean "change the text" (eg, translate), you can do so with
MapGuide Maestro, or you can manually modify the underlying xml.
If you mean "alter functionality", you can look in the
"ajaxmappane.templ" file and modify the javascript there.

Regards, Kenneth Skovhede, GEOGRAF A/S



Rui Daniro skrev:
> Hi all,
>
> I am usig MGE 2009 and I would like to know if it is possible edit/costumize
> built-in commands. If yes, where and how can I get the code.
>
> Thanks in advance.
>
> Rui
>
_______________________________________________
mapguide-users mailing list
mapguide-users at ...<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2383299&i=0>
http://lists.osgeo.org/mailman/listinfo/mapguide-users
________________________________
This email is a reply to your post @ http://n2.nabble.com/Weblayouts-Buil-in-commands-tp2383047p2383299.html
You can reply by email or by visting the link above.


No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.7/1982 - Release Date: 03/03/09 16:09:00

________________________________
View this message in context: RE: [mapguide-users] Weblayouts Buil-in commands<http://n2.nabble.com/Weblayouts-Buil-in-commands-tp2383047p2450420.html>
Sent from the MapGuide Users mailing list archive<http://n2.nabble.com/MapGuide-Users-f1803227.html> at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090309/aed81ce1/attachment.html