I'm really sure that i have exactly the same record size on both tables. Any
way, i use MySql as joined table. Maybe this is another weakness of MySql. I
also has another problem with joined record. If i made a query which return no
result then MGOS server will get crash. I have to start this service after
that. Unfortunately MGOS 1.2 and MapStudio only support MySql. Hopefully next
release will support postgis as well
Ary Sucaya
----- Original Message ----
From: Bruce Dechant <[EMAIL PROTECTED]>
To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org>
Sent: Wednesday, December 12, 2007 9:57:24 PM
Subject: RE: [mapguide-users] FeatureReader
The reason you might be only getting a smaller subset of the data could be the
type of join you setup.
If the primary only has 100 records and the secondary has 300 records and you
are doing a 1 to 1 join – you will only end up with 100 records in your result
set.
Try creating a Left Outer join with a one-to-many relationship to see if all
your data is returned.
Bruce
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ary sucaya
Sent: Tuesday, December 11, 2007 10:19 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] FeatureReader
Thank for replying,
There is no exception. Here is my code:
try
{
MgInitializeWebTier ($configFilePath);
$userInfo = new MgUserInformation($sessionId);
$siteConnection = new MgSiteConnection();
$siteConnection->Open($userInfo);
$resourceService =
$siteConnection->CreateService(MgServiceType::ResourceService);
$map = new MgMap($siteConnection);
$map->Open($mapName);
$featureService =
$siteConnection->CreateService(MgServiceType::FeatureService);
$queryOptions = new MgFeatureQueryOptions();
$queryOptions->SetFilter("FeatId > 0");
$layer = $map->GetLayers()->GetItem("District");
$featureResId = new MgResourceIdentifier($layer->GetFeatureSourceId());
$featureReader = $featureService->SelectFeatures($featureResId,
$layer->GetFeatureClassName(), $queryOptions);
while ($featureReader->ReadNext())
{
echo $featureReader->GetInt32('DistrictID') . "<br />";
}
$featureReader->Close();
}
catch (MgException $e)
{
echo $e->GetMessage();
echo $e->GetDetails();
}
I have more than 300 record in layer District, but I can only see 100 record
out of 300. I don't know what wrong..
Thanx,
Ary Sucaya
----- Original Message ----
From: Bruce Dechant <[EMAIL PROTECTED]>
To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org>
Sent: Tuesday, December 11, 2007 8:30:29 PM
Subject: RE: [mapguide-users] FeatureReader
There is no limit. Is an exception being thrown? If so that would give you a
clue as to why it is not working as expected.
Thanks,
Bruce
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ary sucaya
Sent: Monday, December 10, 2007 9:20 AM
To: Mapguide User
Subject: [mapguide-users] FeatureReader
Hii group,
I have a problem with feature reader. I have a sdf layer joined with external
table and i can't make a looping for all of this records. It's always jump out
the loop after 100 records. I tried the same code with different sdf layer
without join to external layer, it's work well.
Is there any limitation of joined layer in MapGuide 1.2? Anyone can help me?
regards,
Ary Sucaya
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users