[mapguide-users] OSGeo FDO problem...

[Andrew DeMerchant]

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

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