[mapguide-users] OSGeo FDO problem...

Mon Jul 10 14:37:31 EDT 2006

Oh, I actually thought you were using the OGR provider to access your
MDB also, but either way I was wrong. Anyway, it looks like the problem
must be somewhere in the ODBC provider and not in FDO itself.

Traian

  _____  

From: Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca] 
Sent: Monday, July 10, 2006 10:25 AM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] OSGeo FDO problem...

ODBC.....I posted the problem first under PostGIS, but them quickly said
that it wasn't actually PostGIS, and that it was ODBC....sorry if you
missed that! 

Traian Stanev wrote: 

	I thought the problem was with PostGIS, that's why I used
that... So the problem actually happens when using an Access DB? Can you
specifically confirm if that happens when using the ODBC provider or the
OGR provider?

	Traian

  _____  

	From: Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca] 
	Sent: Monday, July 10, 2006 10:09 AM
	To: users at mapguide.osgeo.org
	Subject: Re: [mapguide-users] OSGeo FDO problem...

	Well, all I know is that as soon as I took out the space in the
table name, it fixed it. I'd say that your test should be (to be
consistant with what I did) to make an Access DB...Then make a table
with a space in the name. Then just make 3 fields (a key, a northing and
an easting). Type in some coords (anything should do) and then try to
use that. It should crash as soon as you check "geometry". 

	Andrew

	Traian Stanev wrote:

		Hi Andrew,

		I finally had time to look into the OGR/PostGIS problem.
MapGuide worked fine with a table that has a space in its name. My table
was called "world cities" and contained point data. I also tried adding
a simple attribute filter to the layer ("name" > 'L'), and that also
worked fine.

		So, there must be something else going on with your
table that's throwing off the SQL. FYI, I created my test table by
importing an shp file into pgsql, not sure if that would make a
difference.

		Traian

  _____  

		From: Andrew DeMerchant
[mailto:andrew.demerchant at gemtec.ca] 
		Sent: Tuesday, July 04, 2006 9:16 AM
		To: users at mapguide.osgeo.org
		Subject: Re: [mapguide-users] OSGeo FDO problem...

		Heh.....very understandable! 

		Andrew

		Traian Stanev wrote:

			Sorry, I have not had a chance to look at this
yet. Currently the problem is that they only have 24 hours in a day...

			Traian

			-----Original Message-----
			From:   Andrew DeMerchant
[mailto:andrew.demerchant at gemtec.ca]
			Sent:   Fri 6/30/2006 4:03 PM
			To:     users at mapguide.osgeo.org
			Cc:    
			Subject:        Re: [mapguide-users] OSGeo FDO
problem...

			How's this going? Any progress?

			Andrew

			Traian Stanev wrote:

			>
			> Well, I looked at the code and can't tell
offhand why it wouldn't be
			> working. I'll have to dust off my postgis and
try it with a table name
			> with spaces to see what's going on. I'll post
again when I've fixed it.
			>
			> Cheers,
			> Traian
			>
			>
			> -----Original Message-----
			> From:   Andrew DeMerchant
[mailto:andrew.demerchant at gemtec.ca]
			> Sent:   Wed 6/28/2006 10:41 AM
			> To:     users at mapguide.osgeo.org
			> Cc:   
			> Subject:        Re: [mapguide-users] OSGeo FDO
problem...
			>
			> No filter...
			>
			> Traian Stanev wrote:
			>
			> >
			> > Hmm. It could be that the provider is being
careless with filter
			> > conversion to string. Do you have a filter
set on the layer, or are
			> > you simply trying to preview the whole layer
with no filter?
			> >
			> >
------------------------------------------------------------------------
			> > *From:* Andrew DeMerchant
[mailto:andrew.demerchant at gemtec.ca]
			> > *Sent:* Wednesday, June 28, 2006 9:59 AM
			> > *To:* users at mapguide.osgeo.org
			> > *Subject:* Re: [mapguide-users] OSGeo FDO
problem...
			> >
			> > I'd love to try that, but where do I have
that option? I'm using
			> > Studio...I see no place to either use an SQL
statement of my own, or
			> > to put anything (let alone quotes) around a
table name.
			> >
			> > Andrew
			> >
			> > Robert Fortin wrote:
			> >
			> >> Andrew,
			> >>
			> >> Have you tried using single quote around
you table name/column?
			> >>
			> >> RF
			> >>
			> >>
			>
------------------------------------------------------------------------
			> >> *From:* Andrew DeMerchant
[mailto:andrew.demerchant at gemtec.ca]
			> >> *Sent:* Wednesday, June 28, 2006 9:24 AM
			> >> *To:* users at mapguide.osgeo.org
			> >> *Subject:* [mapguide-users] OSGeo FDO
problem...
			> >>
			> >> It seems that the OSGeo FDO provider
doesn't like spaces in table
			> >> names. The error log said that the FDO was
causing a "Syntax error in
			> >> FROM clause". Is this something that can be
fixed? It should be a
			> >> pretty simple fix, really..since I'd guess
that all that needs to be
			> >> done is to enclose table names (and field
names, for that matter) in
			> >> square brackets (ie, [Table Name], or
[Table Name].[Field Name]). The
			> >> work around for me for now is to make
another Access database and
			> >> link all of the tables from my real
database. In this new database, I
			> >> just rename the tables to get rid of the
spaces. But I can't really
			> >> rely on his workaround, because having to
change table names means
			> >> changing a lot of other things for other
projects (this database is
			> >> used in a lot of other ways, not just
MapGuide). Is there any chance
			> >> that this FDO can get modified to account
for these spaces?
			> >>
			> >> Andrew
			> >>
			> >> --
			> >>      *Andrew DeMerchant*
			> >> *Computer Technologist*
			> >> ph.1-877-4GEMTEC x.163
			> >> fax 506-453-9470
			> >>
			> >> /GEMTEC Limited <http://www.gemtec.ca>
			> >> /191 Doak Road
			> >> Fredericton, NB, Canada
			> >> E3C 2E6
			> >>
			> >
			> > --
			> >       *Andrew DeMerchant*
			> > *Computer Technologist*
			> > ph.1-877-4GEMTEC x.163
			> > fax 506-453-9470
			> >
			> > /GEMTEC Limited <http://www.gemtec.ca>
			> > /191 Doak Road
			> > Fredericton, NB, Canada
			> > E3C 2E6
			> >
			>
			> --
			>         *Andrew DeMerchant*
			> *Computer Technologist*
			> ph.1-877-4GEMTEC x.163
			> fax 506-453-9470
			>
			> /GEMTEC Limited <http://www.gemtec.ca>
			> /191 Doak Road
			> Fredericton, NB, Canada
			> E3C 2E6
			>
			>
			>
			>
			>
------------------------------------------------------------------------
			>
			>
			>
------------------------------------------------------------------------
			>
			>
			>
------------------------------------------------------------------------
			>

>-----------------------------------------------------------------------
-
			>

>---------------------------------------------------------------------
			>To unsubscribe, e-mail:
users-unsubscribe at mapguide.osgeo.org
			>For additional commands, e-mail:
users-help at mapguide.osgeo.org
			>

			--
			        *Andrew DeMerchant*
			*Computer Technologist*
			ph.1-877-4GEMTEC x.163
			fax 506-453-9470

			/GEMTEC Limited <http://www.gemtec.ca>
			/191 Doak Road
			Fredericton, NB, Canada
			E3C 2E6

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20060710/3069a7a9/attachment.html