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

[Rui Daniro]

Hi Dave, 

Sorry about the mess with thread names.

Thanks a lot for your help. I am using Mapguide Studio 2009 and my database
platform is PostgreSQL.
What do you mean with creating views in my database? I am a newbie with
database and programming. 

I am using VISTA as OS and I can connect my non-geographic data via ODBC, so
I will try to connect or create a Join to my OGR greographic data.



Dave Wilson wrote:
> 
> 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.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Weblayouts-Buil-in-commands-tp2383047p2454862.html
Sent from the MapGuide Users mailing list archive at Nabble.com.