[Tilecache] postGis table problem

[Guillaume Sueur]

it looks like a piece of comments is inside your SQL query. Funny !

Guillaume

Walter Lorenzetti a écrit :
> Hi All,
> 
> I've a problem with a postgis layer
> 
> my .cfg declaration:
> 
> [pglayer]
> type=PostGIS
> dsn=host=localhost dbname=mydbname user=myuser password=mypassword
> layer=mytable
> fid=gid
> geometry=the_geom
> 
> when I try:
> 
> http://localhost/webgis/fs/featureserver.cgi/pglayer?maxfeature=1
> 
> I obtain the seguent error:
> 
> An error occurred: syntax error at or near "to"
> LINE 1: SELECT AsText(the_geom # defaults to the_geom) as fs_text_ge...
>                                           ^
> 
>   File "/var/www/webgis/fs/FeatureServer/Server.py", line 298, in cgiHandler
>     format, content = service.dispatchRequest( params, path_info, host, post_data, request_method, accepts )
>   File "/var/www/webgis/fs/FeatureServer/Server.py", line 145, in dispatchRequest
>     result = method(action)
>   File "/var/www/webgis/fs/FeatureServer/DataSource/PostGIS.py", line 203, in select
>     cursor.execute(str(sql), attrs)
> 
> I don't understand where is the problem
> 
> someone can help me?
> 
> Thanks in advance
> 
> Walter