M
To: mapguide-users@lists.osgeo.org
Subject: Re: [mapguide-users] MS SQL and SDF Join Problem
This is the last week before my presentation about the capablity of MGOS to
my client. This is the only issue that i stucked on,at least for now.
Unfortunately i stucked on the very basic but important task! S
This is the last week before my presentation about the capablity of MGOS to
my client. This is the only issue that i stucked on,at least for now.
Unfortunately i stucked on the very basic but important task! So if anyone's
of you really have some time to spend to figure out my problem, i really
ap
What version of MS SQL Server are you using?
- Jackie
anakando wrote:
>
> I guess there is not much i can do except exporting my sdf file to
> external data and yes, this is the thing that most of the clients does not
> like.
>
>
> Rock Beans wrote:
>>
>> I have seen this issue with the SQL
I guess there is not much i can do except exporting my sdf file to external
data and yes, this is the thing that most of the clients does not like.
Rock Beans wrote:
>
> I have seen this issue with the SQL Spatial FDO provider as well. The
> join options don't work everything is always one-to-o
I have seen this issue with the SQL Spatial FDO provider as well. The
join options don't work everything is always one-to-one which means
only objects with data in the joined table show up on map, not good. I
also have seen this on Oracle, this seems to be an ongoing FDO issue
within MapGuide. Sorr
Joins may fail on strings if there are differences in case
See: http://trac.osgeo.org/mapguide/ticket/502
- Jackie
anakando wrote:
>
> Yes..my MG version is 2.0.1..Here is my situation. I have database that
> contain 2 tables (as example). Both of tables are linked to SDF file using
> unique
Try linking the tables with integer columns, that is usually the only
stable solution.
Regards, Kenneth Skovhede, GEOGRAF A/S
anakando skrev:
Yes..my MG version is 2.0.1..Here is my situation. I have database that
contain 2 tables (as example). Both of tables are linked to SDF file using
uni
Yes..my MG version is 2.0.1..Here is my situation. I have database that
contain 2 tables (as example). Both of tables are linked to SDF file using
unique id,and both data type are set to 'varchar'. Out of my curiosity, only
1 table are successfull linked to sdf, but the other one are not. It only
also which version are you running 2.0.1?
On Fri, Sep 12, 2008 at 2:54 PM, Jackie C. Ng <[EMAIL PROTECTED]>wrote:
>
> Are you joining on strings?
>
> - Jackie
>
>
> anakando wrote:
> >
> > Hi guys..
> > I faced a very big problem (i guess) since i cannot overcome this problem
> > for almost 2 wee
Are you joining on strings?
- Jackie
anakando wrote:
>
> Hi guys..
> I faced a very big problem (i guess) since i cannot overcome this problem
> for almost 2 weeks! Let me simplify my problem. I have successful makes a
> join between my sdf file and MS SQL, but the problem is,after joining,it
Hi guys..
I faced a very big problem (i guess) since i cannot overcome this problem
for almost 2 weeks! Let me simplify my problem. I have successful makes a
join between my sdf file and MS SQL, but the problem is,after joining,it
only show only first row data form MS SQL. The type of join is inne
11 matches
Mail list logo
