[mapguide-users] OSGeo FDO problem...

Andrew DeMerchant andrew.demerchant at gemtec.ca
Mon Jul 10 10:25:08 EDT 2006 

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

-------------- next part --------------
Skipped content of type multipart/related

More information about the Mapguide-users mailing list