<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5346.5" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=296333318-10072006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=296333318-10072006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=296333318-10072006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andrew DeMerchant
[mailto:andrew.demerchant@gemtec.ca] <BR><B>Sent:</B> Monday, July 10, 2006
10:25 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> Re:
[mapguide-users] OSGeo FDO problem...<BR></FONT><BR></DIV>
<DIV></DIV>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! <BR><BR>Traian Stanev wrote:
<BLOCKQUOTE
cite=mid0345418B84C1684C8467DC5A2D7EFF6A020FD457@msgusaebk01.autodesk.com
type="cite">
<META content="MSHTML 6.00.5346.5" name=GENERATOR>
<DIV dir=ltr align=left> </DIV>
<DIV dir=ltr align=left><SPAN class=700371914-10072006><FONT face=Arial
color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=700371914-10072006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=700371914-10072006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andrew DeMerchant [<A
class=moz-txt-link-freetext
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]
<BR><B>Sent:</B> Monday, July 10, 2006 10:09 AM<BR><B>To:</B> <A
class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR><B>Subject:</B>
Re: [mapguide-users] OSGeo FDO problem...<BR></FONT><BR></DIV>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". <BR><BR>Andrew<BR><BR>Traian Stanev wrote:<BR>
<BLOCKQUOTE
cite=mid0345418B84C1684C8467DC5A2D7EFF6A020FD456@msgusaebk01.autodesk.com
type="cite">
<META content="MSHTML 6.00.5346.5" name=GENERATOR>
<DIV dir=ltr align=left> </DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006><FONT face=Arial
color=#0000ff size=2>Hi Andrew,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=686263513-10072006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV>
<DIV dir=ltr align=left> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andrew DeMerchant [<A
class=moz-txt-link-freetext
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]
<BR><B>Sent:</B> Tuesday, July 04, 2006 9:16 AM<BR><B>To:</B> <A
class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR><B>Subject:</B>
Re: [mapguide-users] OSGeo FDO problem...<BR></FONT><BR></DIV>Heh.....very
understandable! <BR><BR>Andrew<BR><BR><BR>Traian Stanev wrote:<BR>
<BLOCKQUOTE
cite=mid0345418B84C1684C8467DC5A2D7EFF6A01AE7F74@msgusaebk01.autodesk.com
type="cite">
<META content="MS Exchange Server version 6.0.6618.4" name=Generator><!-- Converted from text/plain format --><BR><BR>
<P><FONT size=2>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...<BR><BR>Traian<BR><BR><BR>-----Original
Message-----<BR>From: Andrew DeMerchant [<A
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]<BR>Sent:
Fri 6/30/2006 4:03 PM<BR>To: <A
class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR>Cc: <BR>Subject:
Re: [mapguide-users] OSGeo FDO problem...<BR><BR>How's this going? Any
progress?<BR><BR>Andrew<BR><BR>Traian Stanev wrote:<BR><BR>><BR>>
Well, I looked at the code and can't tell offhand why it wouldn't
be<BR>> working. I'll have to dust off my postgis and try it with a
table name<BR>> with spaces to see what's going on. I'll post again
when I've fixed it.<BR>><BR>> Cheers,<BR>>
Traian<BR>><BR>><BR>> -----Original Message-----<BR>>
From: Andrew DeMerchant [<A
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]<BR>>
Sent: Wed 6/28/2006 10:41 AM<BR>>
To: <A class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR>>
Cc: <BR>>
Subject: Re: [mapguide-users]
OSGeo FDO problem...<BR>><BR>> No filter...<BR>><BR>> Traian
Stanev wrote:<BR>><BR>> ><BR>> > Hmm. It could be that the
provider is being careless with filter<BR>> > conversion to string.
Do you have a filter set on the layer, or are<BR>> > you simply
trying to preview the whole layer with no filter?<BR>> ><BR>>
>
------------------------------------------------------------------------<BR>>
> *From:* Andrew DeMerchant [<A
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]<BR>>
> *Sent:* Wednesday, June 28, 2006 9:59 AM<BR>> > *To:* <A
class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR>>
> *Subject:* Re: [mapguide-users] OSGeo FDO problem...<BR>>
><BR>> > I'd love to try that, but where do I have that option?
I'm using<BR>> > Studio...I see no place to either use an SQL
statement of my own, or<BR>> > to put anything (let alone quotes)
around a table name.<BR>> ><BR>> > Andrew<BR>> ><BR>>
> Robert Fortin wrote:<BR>> ><BR>> >> Andrew,<BR>>
>><BR>> >> Have you tried using single quote around you
table name/column?<BR>> >><BR>> >> RF<BR>>
>><BR>> >><BR>>
------------------------------------------------------------------------<BR>>
>> *From:* Andrew DeMerchant [<A
href="mailto:andrew.demerchant@gemtec.ca">mailto:andrew.demerchant@gemtec.ca</A>]<BR>>
>> *Sent:* Wednesday, June 28, 2006 9:24 AM<BR>> >> *To:*
<A class=moz-txt-link-abbreviated
href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</A><BR>>
>> *Subject:* [mapguide-users] OSGeo FDO problem...<BR>>
>><BR>> >> It seems that the OSGeo FDO provider doesn't
like spaces in table<BR>> >> names. The error log said that the
FDO was causing a "Syntax error in<BR>> >> FROM clause". Is this
something that can be fixed? It should be a<BR>> >> pretty simple
fix, really..since I'd guess that all that needs to be<BR>> >>
done is to enclose table names (and field names, for that matter)
in<BR>> >> square brackets (ie, [Table Name], or [Table
Name].[Field Name]). The<BR>> >> work around for me for now is to
make another Access database and<BR>> >> link all of the tables
from my real database. In this new database, I<BR>> >> just
rename the tables to get rid of the spaces. But I can't really<BR>>
>> rely on his workaround, because having to change table names
means<BR>> >> changing a lot of other things for other projects
(this database is<BR>> >> used in a lot of other ways, not just
MapGuide). Is there any chance<BR>> >> that this FDO can get
modified to account for these spaces?<BR>> >><BR>> >>
Andrew<BR>> >><BR>> >> --<BR>>
>> *Andrew DeMerchant*<BR>>
>> *Computer Technologist*<BR>> >> ph.1-877-4GEMTEC
x.163<BR>> >> fax 506-453-9470<BR>> >><BR>> >>
/GEMTEC Limited <<A
href="http://www.gemtec.ca">http://www.gemtec.ca</A>><BR>> >>
/191 Doak Road<BR>> >> Fredericton, NB, Canada<BR>> >>
E3C 2E6<BR>> >><BR>> ><BR>> > --<BR>>
> *Andrew DeMerchant*<BR>> >
*Computer Technologist*<BR>> > ph.1-877-4GEMTEC x.163<BR>> >
fax 506-453-9470<BR>> ><BR>> > /GEMTEC Limited <<A
href="http://www.gemtec.ca">http://www.gemtec.ca</A>><BR>> > /191
Doak Road<BR>> > Fredericton, NB, Canada<BR>> > E3C
2E6<BR>> ><BR>><BR>>
--<BR>> *Andrew
DeMerchant*<BR>> *Computer Technologist*<BR>> ph.1-877-4GEMTEC
x.163<BR>> fax 506-453-9470<BR>><BR>> /GEMTEC Limited <<A
href="http://www.gemtec.ca">http://www.gemtec.ca</A>><BR>> /191 Doak
Road<BR>> Fredericton, NB, Canada<BR>> E3C
2E6<BR>><BR>><BR>><BR>><BR>>
------------------------------------------------------------------------<BR>><BR>><BR>>
------------------------------------------------------------------------<BR>><BR>><BR>>
------------------------------------------------------------------------<BR>><BR>>------------------------------------------------------------------------<BR>><BR>>---------------------------------------------------------------------<BR>>To
unsubscribe, e-mail: <A class=moz-txt-link-abbreviated
href="mailto:users-unsubscribe@mapguide.osgeo.org">users-unsubscribe@mapguide.osgeo.org</A><BR>>For
additional commands, e-mail: <A class=moz-txt-link-abbreviated
href="mailto:users-help@mapguide.osgeo.org">users-help@mapguide.osgeo.org</A><BR>><BR><BR>--<BR>
*Andrew DeMerchant*<BR>*Computer Technologist*<BR>ph.1-877-4GEMTEC
x.163<BR>fax 506-453-9470<BR><BR>/GEMTEC Limited <<A
href="http://www.gemtec.ca">http://www.gemtec.ca</A>><BR>/191 Doak
Road<BR>Fredericton, NB, Canada<BR>E3C
2E6<BR><BR><BR><BR></FONT></P><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>