• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk MapGuide Enterprise

    Reply
    Active Member
    Posts: 8
    Registered: ‎08-10-2006

    Highlight selected MySQL objects

    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
    Please use plain text.
    Active Member
    Posts: 8
    Registered: ‎08-10-2006

    Re: Highlight selected MySQL objects

    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
    Please use plain text.
    *James Card

    Re: Highlight selected MySQL objects

    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
    Please use plain text.
    Active Member
    Posts: 8
    Registered: ‎08-10-2006

    Re: Highlight selected MySQL objects

    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
    Please use plain text.
    *James Card

    Re: Highlight selected MySQL objects

    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
    Please use plain text.
    Active Member
    Posts: 8
    Registered: ‎08-10-2006

    Re: Highlight selected MySQL objects

    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
    Please use plain text.
    Contributor
    Posts: 12
    Registered: ‎02-17-2008

    Re: Highlight selected MySQL objects

    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
    Please use plain text.