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

Traian Stanev traian.stanev at autodesk.com
Wed Sep 23 15:46:54 EDT 2009


For what it's worth, I just tried the SQLiteProvider DLL I posted for FDO 3.4 on a MG 2.1 RC install (dated May 1, 2009) and was able to create a SQLite based layer using Maestro and did a multi-select without problems.

I have no reason to think that the 3.3 build is any different from the 3.4 one since I used the same version of the code to compile each one -- granted, for 3.3 I had to use a different version of Visual Studio, but that should not be a problem if you have the runtimes installed.

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: Wednesday, September 23, 2009 2:51 PM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> problem?
>
> Cant get it working Installed both of those and rebooted.
> Installed a 2.1 Beta release on a new machine and tried the 3.4 you gave me
> to no avail, downloaded the official 3.4 driver from OSGEO and Im back to
> having the selection issue again...
> ...Its hard to believe Im the first to need to select more than one object
> with this driver?????
>
> What version do you run that seems to work on selections? What installed
> Mapguide and FDO level/driver?
>
> -----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 12:10 PM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> problem?
>
> Also make sure that you have installed both the regular and SP1 runtimes for
> Visual Studio 2005:
>
> http://www.microsoft.com/downloads/details.aspx?familyid=32BC1BEE-A3F9-4C13-
> 9C99-220B62A191EE&displaylang=en
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-
> 984D-389C36F85647&displaylang=en
>
> It could be that your FDO was compiled with SP1 and the provider is compiled
> without SP1 of the Visual C++ runtime.
>
>
> Traian
>
>
> > -----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 12:55 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> >
> > 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
> > _______________________________________________
> > 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