[mapguide-users] OSGeo FDO problem...

[Andrew DeMerchant]

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 --------------
Skipped content of type multipart/related