Message-
From: mapguide-users-boun...@lists.osgeo.org
[mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Gord McKenzie
Sent: Monday, April 27, 2015 5:29 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Mapguide and ODBC
Here is the scoop.
When the SQL Database has a
-users@lists.osgeo.org
Subject: Re: [mapguide-users] Mapguide and ODBC
I'm afraid at this point, we'll need a small reproducible sample of this
problematic SDF/SQL Server join in order to look at this issue any further.
Something that is 50-100 rows on either side with the sensitive i
ssage-
From: mapguide-users-boun...@lists.osgeo.org
[mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Sunday, April 26, 2015 8:56 PM
To: mapguide-users@lists.osgeo.org
Subject: Re: [mapguide-users] Mapguide and ODBC
I'm afraid at this point, we'll need a small repr
I'm afraid at this point, we'll need a small reproducible sample of this
problematic SDF/SQL Server join in order to look at this issue any further.
Something that is 50-100 rows on either side with the sensitive information
(except for the joining keys) sanitized/replaced should be sufficient.
II
, AB T2R 1L5
-Original Message-
From: mapguide-users-boun...@lists.osgeo.org
[mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Thursday, April 23, 2015 7:05 AM
To: mapguide-users@lists.osgeo.org
Subject: Re: [mapguide-users] Mapguide and ODBC
Just to confirm: You
Just to confirm: You can view the data of the extended feature class just
fine with all the right-side attributes being there, but when you render a
layer off of it you are getting different results?
- Jackie
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODB
Subject: Re: [mapguide-users] Mapguide and ODBC
If your string column is e.g. "typeofhouse" and it is either:
villa
cityhouse
appartment
school
government
create a new int column named typeid
and set an id to each type.
update houses set typeid=1 where typeofhouse='villa'
You
If your string column is e.g. "typeofhouse" and it is either:
villa
cityhouse
appartment
school
government
create a new int column named typeid
and set an id to each type.
update houses set typeid=1 where typeofhouse='villa'
You then have the typeid column updated as this:
villa=1
cityhouse = 2
a
I have migrated and Access database to SQL Server. I am trying to create a
feature join from an sdf file to a sql server table using a string column.
I can create the datasources and the join without too much difficulty. If I
use the preview function on the datasource I can see the record count
