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

Wed Sep 23 14:51:17 EDT 2009

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