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

Traian Stanev traian.stanev at autodesk.com
Wed Sep 23 18:03:27 EDT 2009 

I've posted updated zips at the same location, with a fix for that particular problem. Give them a try and see if you get further.

Thanks,
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 5:15 PM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple Selection
> problem?
>
>
> We'll check your file.
>
> It looks valid to me, but one thing I notice that is different is that the
> geometry column is the last column in your table. There are some
> optimizations in the provider which were added last week, which do different
> SQL queries based on the order of the columns, and there may well be a new
> bug there which I don't see with my data since it is using different order.
> If it turns out to be a bug in the provider, I will post new DLLs and post
> to the list when 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: Wednesday, September 23, 2009 4:44 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> > Email has been sent with attached file to you...If it works good for you
> ill
> > be completely stumped
> >
> > -----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 3:39 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> > Im not sure my files not a defect now..I'll email you a link
> >
> > -----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 2:59 PM
> > To: 'MapGuide Users Mail List'
> > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> Selection
> > problem?
> >
> >
> > Yes, create a defect ticket here: http://trac.osgeo.org/fdo/ and attach a
> > zip of your file to 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: Wednesday, September 23, 2009 3:54 PM
> > > To: 'MapGuide Users Mail List'
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > Selection
> > > problem?
> > >
> > > Can I have you look at my SQLite file and see if its not somehow the
> file?
> > > I'm at a complete loss..
> > > When I make the data connection that goes smoothly..When I try to
> preview
> > in
> > > the data connection a couple layer actually do preview..But when I
> create
> > a
> > > layer and try a preview it goes to a scale of 10...I am thoroughly
> > > exhausted...I could not get the 3.4 to work in Map 2010 at all....but
> > that's
> > > OK.
> > >
> > > If I use the older 3.4 driver from OSGEO my layers display but I get the
> > > selection problem.
> > >
> > > -----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 2:47 PM
> > > To: 'MapGuide Users Mail List'
> > > Subject: RE: [mapguide-users] SQLITE...and Mapguide/AJAX Multiple
> > Selection
> > > problem?
> > >
> > >
> > > 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

More information about the mapguide-users mailing list