[mapguide-users] OSGeo FDO problem...

[Andrew DeMerchant]

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

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