Problems with MySQL

[peter56]

Hi,

my joy was to early ;-( ... 

The connection to database is possible. Also the geometry is shown. But when
I select one line, all lines of the layer are highlighted.

I've tried it with lines now. 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

Sorry, but I'm new with MapGuide and MySQL too.

Thanks in advance.

Regards - Peter


Bruce Dechant wrote:
> 
> Adam,
> 
>  
> 
> Can you supply any addition information like:
> 
>  
> 
> -          Version of MySQL you are using
> 
> -          Geometry type you are having problems with
> 
> -          Version of FDO you are using
> 
>  
> 
> I have been successful in creating maps from MySQL data using (polygons,
> lines and points).
> 
>  
> 
> Bruce
> 
>  
> 
>   _____  
> 
> From: Adam Herbert [mailto:adam at aemsaustralia.com.au] 
> Sent: September 11, 2006 5:43 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] Problems with MySQL
> 
>  
> 
> So I guess that's a no then?
> 
>  
> 
>   _____  
> 
> From: Adam Herbert [mailto:adam at aemsaustralia.com.au] 
> Sent: Thursday, 7 September 2006 9:49 AM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] Problems with MySQL
> 
>  
> 
> Hi,
> 
>  
> 
> Has anybody got FDO's using MySQL data sources working properly? I can
> get it to read the data but it is not selectable and it doesn't seem to
> recognise the geometry types properly.
> 
>  
> 
> Thanks.
> 
> Adam Herbert
> IT Manager
> AEM Solutions Pty Ltd
> PO Box 514, Toowoomba Q. 4350
> Phone: 07 4613 0455
> Cell: 0437 599 907
> Website: www.aemsaustralia.com.au <http://www.aemsaustralia.com.au> 
> 
> Important Disclaimer and Warning
> 
> AEMS does not represent or warrant that any attached files are free from
> computer viruses or other defects. The attached files are provided, and
> may only be used, on the basis that the user assumes all responsibility
> for any loss, damage or consequences resulting directly or indirectly
> from use of the attached files. The liability of AEMS in any event is
> limited to either the re-supply of the attached files or the cost of
> having the attached files re-supplied.
> 
> NOTE: The views expressed by the individual in this message do not
> necessarily reflect those of the organisation.
> 
> AEMS is committed to protecting the privacy of individuals, and is bound
> by the principles of the Commonwealth Privacy Act (1988).
> 
> The information contained in this message is confidential and may be
> legally privileged. The message is intended solely for the addressee(s).
> If you are not the intended recipient, you are hereby notified that any
> use, dissemination, or reproduction is strictly prohibited and may be
> unlawful. If you are not the intended recipient, please contact the
> sender by return e-mail and destroy all copies of the original message.
> 
>  
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Problems-with-MySQL-tf2230264.html#a6524424
Sent from the OSGeo MapGuide mailing list archive at Nabble.com.