[mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection problem?

Traian Stanev traian.stanev at autodesk.com
Wed Sep 23 12:55:23 EDT 2009 

Do you have the DLL dependency tool to check if the provider DLL is not missing any DLL dependency?

Do you have MapStudio by any chance? You can try to see if you get the same problem there.

There should be only one connection property, called "File", are you saying that you cannot see it?


> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-
> bounces at lists.osgeo.org] On Behalf Of Scott hameister
> Sent: Wednesday, September 23, 2009 12:45 PM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> problem?
> 
> Im getting an oddball error when trying to make a data connection in studio
> 2009...
> The Connection Properties for Property, translated Name, Value are showing
> up but have no where to edit them..So I cant do anything
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Traian Stanev
> Sent: Wednesday, September 23, 2009 11:03 AM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> problem?
> 
> 
> I posted builds of the latest SQLite provider code compiled against FDO 3.3
> and also 3.4 at:
> 
> http://13-9.com/SQLiteProvider-3.3.zip
> 
> and
> 
> http://13-9.com/SQLiteProvider-3.4.zip
> 
> respectively. Due to differences in the FDO API, I had to hack around a bit
> of stuff, and I only gave the provider very rudimentary testing (I opened a
> sqlite file and read some data from it).
> 
> Let me know if there are still problems with selection, even with this new
> DLL. If there are, then I suggest you file a bug report against the provider
> and attach some sample data to it so we can debug it.
> 
> Traian
> 
> 
> 
> 
> > -----Original Message-----
> > From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-
> > bounces at lists.osgeo.org] On Behalf Of Scott hameister
> > Sent: Tuesday, September 22, 2009 9:18 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> > THANKS
> >
> > -----Original Message-----
> > From: mapguide-users-bounces at lists.osgeo.org
> > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Traian Stanev
> > Sent: Tuesday, September 22, 2009 8:07 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> >
> > Yeah it will not work. I'll attempt to compile it with 3.3 and post again
> to
> > the list whenever it's done.
> >
> > Traian
> >
> >
> > > -----Original Message-----
> > > From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-
> > > bounces at lists.osgeo.org] On Behalf Of Scott hameister
> > > Sent: Tuesday, September 22, 2009 8:58 PM
> > > To: 'MapGuide Users Mail List'
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > > Selection problem?
> > >
> > > Id be willing to move up to FDO 3.4 But I thought Studio 2009 and
> > > Mapguide
> > > Open Source 2.0.2 Were Permanantly forced to use 3.3...Can I run 3.4 on
> > > these?
> > >
> > > -----Original Message-----
> > > From: mapguide-users-bounces at lists.osgeo.org
> > > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Traian
> > > Stanev
> > > Sent: Tuesday, September 22, 2009 7:41 PM
> > > To: MapGuide Users Mail List
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > > Selection
> > > problem?
> > >
> > >
> > > Well, considering this is FDO 3.3, which is seriously old, there
> > > probably
> > > isn't a build of the latest SQLite provider against FDO 3.3. It would
> > > have
> > > to be a custom build of the trunk 3.5 SQLite FDO code against the old
> > > FDO
> > > 3.3 libraries. I'll check how hard that would be to do, I'm guessing
> > > there
> > > is no chance for you to use FDO 3.4, given that you have deployed
> > > already?
> > >
> > > Traian
> > >
> > > ________________________________________
> > > From: mapguide-users-bounces at lists.osgeo.org
> > > [mapguide-users-bounces at lists.osgeo.org] On Behalf Of Scott hameister
> > > [scotth at mpowerinnovations.com]
> > > Sent: Tuesday, September 22, 2009 7:51 PM
> > > To: 'MapGuide Users Mail List'
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX
> > > Multiple
> > > Selection       problem?
> > >
> > > The Zip Was called FdoSQLiteProvider_3.3.0_r4270 11/26/2008 on
> > > SQLITEPROVIDER.dll
> > >
> > > MapGuide Server (Version 2.0.2.3011)
> > > God I hope yopu are right...Where do you get the newer files?
> > >
> > > -----Original Message-----
> > > From: mapguide-users-bounces at lists.osgeo.org
> > > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Traian
> > > Stanev
> > > Sent: Tuesday, September 22, 2009 6:39 PM
> > > To: MapGuide Users Mail List
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > > Selection
> > > problem?
> > >
> > >
> > > What is the date of your SQLite dll (and what version of MapGuide, FDO)?
> > > There have been numerous fixes done to the SQLite provider in the last
> > > few
> > > months, and your problem has also likely been fixed.
> > >
> > > Traian
> > >
> > > ________________________________________
> > > From: mapguide-users-bounces at lists.osgeo.org
> > > [mapguide-users-bounces at lists.osgeo.org] On Behalf Of Scott hameister
> > > [scotth at mpowerinnovations.com]
> > > Sent: Tuesday, September 22, 2009 6:23 PM
> > > To: 'MapGuide Users Mail List'
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > > Selection       problem?
> > >
> > > I just noticed that making selections on any Layer in studio of
> > > multiple
> > > objects has some odd results as well????
> > > Anyone know why this is? I download my FDo driver from Jason birch's
> > > Website...is there a newer one out there?
> > > I finally got this customer entirely ported over to SQLite and now it
> > > looks
> > > unusable...
> > >
> > > PS just tried the fusion viewr in studio Selected a big square of
> > > objects...the Fusion viewer shows I selected 84 objects based on the
> > > selection tab, but the map visually only shows about 8 objects selected
> > > randomly through my original box.
> > >
> > > Anyone having success with multiple selections/or facing the same
> > > problem.????????
> > >
> > > -----Original Message-----
> > > From: mapguide-users-bounces at lists.osgeo.org
> > > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Flipper
> > > Sent: Tuesday, September 22, 2009 5:08 PM
> > > To: mapguide-users at lists.osgeo.org
> > > Subject: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> > > problem?
> > >
> > >
> > > I'm Trying to utilize SQLITE in Mapguide...
> > > I'm succesfully getting and creating selection filters with the API...I
> > > see
> > > the Appropriate XML (see below)...
> > > I sent this into the AJAX
> > > myframe.mapFrame.SetSelectionXML(selectionXml);
> > > and refreshed and it only selects one object...I noticed the same
> > > problem
> > > When I make a rectangular selection over several objects and it Reports
> > > back
> > > only one objects...Im confused as to what is happening here....
> > > Anybody else having any issues? Mapguide 2.0 OS
> > >
> > > This is the Selection XML being sent into
> > > myframe.mapFrame.SetSelectionXML
> > > <?xml version="1.0" encoding="UTF-8"?><FeatureSet
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd"> <Layer
> > > id="0e2be5e2-0000-1000-8001-000423cc7e07"> <Class id="Default:SANPIPE">
> > > <ID>EgAAAA==</ID> <ID>EwAAAA==</ID> <ID>FAAAAA==</ID> <ID>FQAAAA==</ID>
> > > <ID>FgAAAA==</ID> <ID>FwAAAA==</ID> <ID>GAAAAA==</ID> <ID>GQAAAA==</ID>
> > > <ID>GgAAAA==</ID> <ID>GwAAAA==</ID> <ID>HAAAAA==</ID> <ID>HQAAAA==</ID>
> > > <ID>HgAAAA==</ID> <ID>HwAAAA==</ID> <ID>IAAAAA==</ID> <ID>IQAAAA==</ID>
> > > <ID>IgAAAA==</ID> <ID>IwAAAA==</ID> <ID>JAAAAA==</ID> <ID>JQAAAA==</ID>
> > > <ID>JgAAAA==</ID> <ID>JwAAAA==</ID> <ID>KgAAAA==</ID> <ID>KwAAAA==</ID>
> > > <ID>LAAAAA==</ID> <ID>LQAAAA==</ID> <ID>LgAAAA==</ID> <ID>LwAAAA==</ID>
> > > <ID>MAAAAA==</ID> <ID>MQAAAA==</ID> <ID>MgAAAA==</ID> <ID>MwAAAA==</ID>
> > > <ID>NAAAAA==</ID> <ID>NQAAAA==</ID> <ID>OwAAAA==</ID> <ID>PAAAAA==</ID>
> > > <ID>RQAAAA==</ID> <ID>RgAAAA==</ID> <ID>SAAAAA==</ID> <ID>SQAAAA==</ID>
> > > <ID>SgAAAA==</ID> <ID>TQAAAA==</ID> <ID>TgAAAA==</ID> <ID>TwAAAA==</ID>
> > > <ID>UAAAAA==</ID> <ID>UQAAAA==</ID> <ID>tAAAAA==</ID> <ID>tQAAAA==</ID>
> > > </Class> </Layer></FeatureSet>
> > > --
> > > View this message in context:
> > > http://n2.nabble.com/SQLITE-and-Mapguide-AJAX-Multiple-Selection-
> > > problem-tp3
> > > 696007p3696007.html
> > > Sent from the MapGuide Users mailing list archive at Nabble.com.
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > >
> > >
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > >
> > >
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > >
> > >
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> >
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users

More information about the mapguide-users mailing list