Highlight selected MySQL objects

[Peter65]

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

[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

[Anonymous]

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

[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

[Anonymous]

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

[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

[Reshma]

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