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

Scott hameister scotth at mpowerinnovations.com
Wed Sep 23 15:37:07 EDT 2009


I tried The 3.4 You gave me in 2010 it gives me a connection error,
I tried the 3.4 you gave me in MGOS 2.1 beta and none of the layers can
preview but one does show in the map?
I really liked the Idea of SQLite for this user...But Im afraid I have to
give upo unless someone can actually tell me a combo that works...I don't
wanna give up but the deadline is upon me....and No one has told me You can
make it work in some combination

-----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




More information about the mapguide-users mailing list