Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2013-07-10 Thread flavio rigolon
Hi Dennis, after more than one year :-)...but in these days I've migrated my qgis-web-client to another machine and I've encoutered the same message in firebug: "illegal character #!/usr/bin/python" > But when I try to write a searchtext in the client, Firebug gives the error > message: > >

Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Dennis Ströer
Hey Bernhard, thank you for the advice, this solution seems to be logical. I created a view like you told me. After this I changed the GlobalOptions.js to: var useGeoNamesSearchBox = false; var searchBoxQueryURL = "/wsgi/search.wsgi?query="; var searchBoxGetGeomURL = "/wsgi/getSearchGeom.wsgi

Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Bernhard Ströbl
Hi Dennis, the documentation might be a bit misleading. In fact you have to insert with to_tsvector(somestring). I normally use views as search relations so if I have a table streets(gid, the_geom, streetname) it would be something like CREATE OR REPLACE VIEW search_streets AS SELECT streetna

Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Dennis Ströer
Am 25.06.2012 14:09, schrieb Bernhard Ströbl: Hi Dennis, please try to execute SELECT to_tsvector('bla') in a SQL shell. What happens? Your error message indicates you call the funtion without an argument. Maybe you should read the doc on the Full text Search http://www.postgresql.org/docs/8.4/s

Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Niccolo Rigacci
On Mon, Jun 25, 2012 at 01:11:56PM +0200, Dennis Ströer wrote: > > ERROR: function to_tsvector() does not exist > > I'm using PostgreSQL 8.4, so I think the tsearch package is already > included?! And when I add a new column to a table I can select the > data type tsvector... If I can remember w

Re: [Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Bernhard Ströbl
Hi Dennis, please try to execute SELECT to_tsvector('bla') in a SQL shell. What happens? Your error message indicates you call the funtion without an argument. Maybe you should read the doc on the Full text Search http://www.postgresql.org/docs/8.4/static/textsearch.html and/or the tsvector data

[Qgis-user] QGIS Webclient PostgreSQL search table

2012-06-25 Thread Dennis Ströer
Hello everybody, I'm testing the QGIS webclient in the moment. Thanks for developing such a great project! Its a nice tool and the default settings and functionality works fine. Now I'm trying to realize the search with wsgi and a PostgreSQL table setup for searching like explained in the cha