Autodesk MapGuide Enterprise
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
119 Views, 6 Replies
10-01-2006 12:21 PM
Hi @all,
and thanks for creating this group :-).
Here my first question. Sorry for cross post (OSGeo) but the following problem is unsolved:
I've loaded geometry objects from MySQL database. The connection to the database is possible. Also the geometry is shown. But when I select one line, all lines of the layer are highlighted. Interesting is, that the tooltip works correctly.
Here is a code example for inserting the lines into MySQL:
insert into tra_strasse_geometrie(strageo_geo, strageo_name_id) Values (geomfromtext('linestring(4531094.71 5686671.65,4531027.17 5686674.21)'), 7);
The table "tra_strasse_geometrie" is of MyISAM type and the row "strageo_geo" is of type GEOMTERY with index.
I'm using MySQL 5.0.24, MGOS 1.0.1, MG Studio 1.0.0, AJAX viewer.
Sorry, but I'm new with MGE and MySQL too.
Thanks in advance.
Regards - Peter
and thanks for creating this group :-).
Here my first question. Sorry for cross post (OSGeo) but the following problem is unsolved:
I've loaded geometry objects from MySQL database. The connection to the database is possible. Also the geometry is shown. But when I select one line, all lines of the layer are highlighted. Interesting is, that the tooltip works correctly.
Here is a code example for inserting the lines into MySQL:
insert into tra_strasse_geometrie(strageo_geo, strageo_name_id) Values (geomfromtext('linestring(4531094.71 5686671.65,4531027.17 5686674.21)'), 7);
The table "tra_strasse_geometrie" is of MyISAM type and the row "strageo_geo" is of type GEOMTERY with index.
I'm using MySQL 5.0.24, MGOS 1.0.1, MG Studio 1.0.0, AJAX viewer.
Sorry, but I'm new with MGE and MySQL too.
Thanks in advance.
Regards - Peter
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-27-2006 05:07 AM in reply to:
Peter65
Hi @all,
after installing SP1 for the studio and using MGOS 1.0.2, a part of the problem is solved. But only a part: selecting an object leads to highlighting it.
But now I have an other problem. The selection is sometimes not correct. I want say, moving the cursor over one object, the tool shows the information of an other object an select and highlight the other object.
Can anybody help?
Thanks in advance - Peter
after installing SP1 for the studio and using MGOS 1.0.2, a part of the problem is solved. But only a part: selecting an object leads to highlighting it.
But now I have an other problem. The selection is sometimes not correct. I want say, moving the cursor over one object, the tool shows the information of an other object an select and highlight the other object.
Can anybody help?
Thanks in advance - Peter
*James Card
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-27-2006 10:55 AM in reply to:
Peter65
On Mon, 27 Nov 2006 05:07:05 -0800, Peter65 wrote:
> But now I have an other problem. The selection is sometimes not correct.
> I want say, moving the cursor over one object, the tool shows the
> information of an other object an select and highlight the other object.
Probably not much help, but we have a dataset that exhibits similar
behavior. The zoom-to function zooms to and selects the correct feature,
but the report in the Properties pane displays data for an adjacent
feature (which always has a key value that is one greater or less than the
key for the selected object).
This can be seen at < ="">, do an address
search (for "1040" as an example) and then zoom to various parcels in the
result set. For example, zooming to 1040 Monterra Ln produces a report for
1119 DeMoll Dr.
--
James Card>
> But now I have an other problem. The selection is sometimes not correct.
> I want say, moving the cursor over one object, the tool shows the
> information of an other object an select and highlight the other object.
Probably not much help, but we have a dataset that exhibits similar
behavior. The zoom-to function zooms to and selects the correct feature,
but the report in the Properties pane displays data for an adjacent
feature (which always has a key value that is one greater or less than the
key for the selected object).
This can be seen at < ="">, do an address
search (for "1040" as an example) and then zoom to various parcels in the
result set. For example, zooming to 1040 Monterra Ln produces a report for
1119 DeMoll Dr.
--
James Card>
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-28-2006 12:28 AM in reply to:
Peter65
Thanks for reply. What FDO are you using. I ask, because I have this behavior with MySQL. When I use the same geometry from shape-files, then it works fine.
Best regards - Peter
Best regards - Peter
*James Card
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-28-2006 08:58 AM in reply to:
Peter65
On Tue, 28 Nov 2006 00:28:51 -0800, Peter65 wrote:
> Thanks for reply. What FDO are you using. I ask, because I have this
> behavior with MySQL. When I use the same geometry from shape-files, then
> it works fine.
Data was originally shapefiles, but we had MapGuide Studio convert it to
SDF when it was loaded into the repository.
--
James Card
> Thanks for reply. What FDO are you using. I ask, because I have this
> behavior with MySQL. When I use the same geometry from shape-files, then
> it works fine.
Data was originally shapefiles, but we had MapGuide Studio convert it to
SDF when it was loaded into the repository.
--
James Card
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-29-2006 12:32 AM in reply to:
Peter65
With shapefiles I had no problems (exported from Autodesk MAP). Only with MySQL.
However I found a first solution :-). Yesterday I installed the dwf-viewer and it works fine :-)!!! Perhaps this could help you too?
Best regards - Peter
However I found a first solution :-). Yesterday I installed the dwf-viewer and it works fine :-)!!! Perhaps this could help you too?
Best regards - Peter
Re: Highlight selected MySQL objects
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-20-2008 03:08 AM in reply to:
Peter65
i think till now you will beccome master in mysql and mapguide studio and data connectivity bt i don't know anything about connectivity ,please guide me .what is procedure of data connection
thanks
thanks

