[mapguide-users] OSGeo FDO problem...

[Andrew DeMerchant]

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

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