My question is for Mapguide Enterprise but someone might have a solution here.
I have a layer that uses a join of an ODBC connection to an Access database and an Oracle connection (Autodesk provider). The ODBC stores multiple rows for each Oracle feature so I'm using a one-to-many left join. I'm using the attribute ProjectId from both tables to do the join. The features display in the map just fine but I am having a problem querying a specific feature by running an Invoke URL command in Mapguide Studio. I wrote a script based on the Generic Tasks query script that queries features by attribute only and my queries run ok except for one feature. I traced the problem to this line: For a reason I don't understand the reader is empty so when I call nothing happens returning empty results. It's obvious that the feature is there since I can see it in the map and I'm invoking an URL from it. Also that attribute is correctly passed to the invoked script that runs the query. If I use the filter "ProjectId = '09-802'" in the layer, the features display but I can't query them. Does anybody an idea why? Again this happens only with one feature, all other queries run fine. I tried switching to an inner join with no effect. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Problem-quering-joined-tables-tp6839081p6839081.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
