Even Rouault mines-paris.org> writes:
> I've looked at WFS 1.1 spec, and at page 17 (ยง7.3 Property names), I see that
> the definition of the property name allows a dot character. So this is
> theoretically valid...
TinyOWS is now theoretically fixed
https://github.com/mapserver/tinyows/iss
Cc: Rahkonen Jukka
Subject: Re: [gdal-dev] OGR SQL: Excecuting select where column name contains
"."
> There may be something wrong with TinyOWS but it must be noted that it
> has passed all the CITE tests for WFS 1.0.0 and 1.1.0. If so well
> tested server fails with dots i
ubject: Re: [gdal-dev] OGR SQL: Excecuting select where column name contains
"."
Even Rouault wrote:
>> I can confirm that it is not illegal per se because the following
>> works. I hope that the backslashes and everything go through properly.
>
>> ogrinfo WFS:http:/
> There may be something wrong with TinyOWS but it must be noted that it has
> passed all the CITE tests for WFS 1.0.0 and 1.1.0. If so well tested
> server fails with dots in the field names it is very probable that there
> are lots of other servers and clients which will fail too.
The CITE tes
Even Rouault wrote:
>> I can confirm that it is not illegal per se because the following works. I
>> hope that the backslashes and everything go through properly.
>
>> ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows
>> -sql "select \"nom.dept\" from \"tows:dot.test\""
>
>> It is an open WFS server
> I can confirm that it is not illegal per se because the following works. I
> hope that the backslashes and everything go through properly.
>
> ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows
> -sql "select \"nom.dept\" from \"tows:dot.test\""
>
> It is an open WFS server and you can test it wi
Odd Ragnar Lydersen powel.no> writes:
>
> I see you have been busy discussing how to handle column names which contain
dot "."
> My problem is that I can't get any reasonable values from the query I make,
whether I use "str1.str2" or
> 'str1.str2' in my expression.
> Please help, or confir
r confirm if I'm trying to do something illegal
>Odd-Ragnar<
-Original Message-----
From: Even Rouault [mailto:even.roua...@mines-paris.org]
Sent: 5. oktober 2012 18:39
To: Rahkonen Jukka
Cc: gdal-dev@lists.osgeo.org
Subject: Re: [gdal-dev] OGR SQL: Excecuting select where column
> To follow SQL, it is recommended to you double-quote
> characters,
> > which might require SHELL escaping since they are already in a
> double-quoted
> > string, like :
>
> Yes, that's a good theory but it is not easy to use it on Windows. Does
> anybody in the world know how should this one be
Even Rouault wrote:
Selon Jukka Rahkonen :
>> > This should definitely work too, but it does not
>> > >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from
>> tows:
>> > france"
>> > INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows'
>> > using driver `WFS' success
Selon Jukka Rahkonen :
> Jukka Rahkonen mmmtike.fi> writes:
>
> > This should definitely work too, but it does not
> > >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from
> tows:
> > france"
> > INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows'
> > using driver `
Jukka Rahkonen mmmtike.fi> writes:
> This should definitely work too, but it does not
> >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from
> >tows:
> france"
> INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows'
> using driver `WFS' successful.
> ERROR 1: SQL Exp
Odd Ragnar Lydersen powel.no> writes:
>
> When I use single quotes, I get no errors, but instead I get returned the
column name = FIELD_1, and all values
> = column.name.one
> I'm using the ExecuteSql() on a WFS datasource, so it might be the WFS driver
which causes the undesired
I believe that
nal Message-
From: Jeff Lake [mailto:ad...@michiganwxsystem.com]
Sent: 4. oktober 2012 14:11
To: Odd Ragnar Lydersen
Subject: Re: [gdal-dev] OGR SQL: Excecuting select where column name contains
"."
use single quotes
eg 'column.name.one'
-Jeff Lake
MichiganWxSystem.com
Alliso
Hi,
You haven't said which platform and binding/command line you are using.
In linux command line you would probably replace "." with "\."
Also column name should probably enclosed in quotes, not brackets.
Etienne
On Thu, Oct 4, 2012 at 8:29 AM, Odd Ragnar Lydersen
wrote:
> Is it possible to
Is it possible to make OGRDataSource:: ExecuteSQL() to work with a column name
containing "."?
Here is an example:
select column.name.one, column.name.two from 'wfs:layerName'
I have tried to enclose the column name in [] brackets, but that was invalid as
well.
Any ideas on how to get around th
16 matches
Mail list logo
