Dear list,
yesterday I reported problems with my WFS server. I could not fix that
up till now.
I have another possibly related problem.
My WMS is set up allright, getcapabilities is ok, I can see the map, pan
zoom, etc, no problems.
When I do an Identify (GetFeatureInfo request), I get
Hi,
Have you tried to run the SQL queries from logfile directly? I wonder if for
example this part is correct and finds any data:
WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry
setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508
Jukka,
Thank you, I've tried the SQL statement:
DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from
NL.IMRO.0026.SVBBU-0001 WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and
(tc_vlak_geometry setSRID(
Hi,
Mapserver needs an integer type column for the USING UNIQUE clause, not
a string column. That won't work.
Best regards,
Bart
DeDuikertjes wrote:
Jukka,
Thank you, I've tried the SQL statement:
DECLARE mycursor BINARY CURSOR FOR SELECT
List,
Thanks to Bart van den Eijnden the problem is solved.
I used a using unique clause on a column which was unique, but not
integer.
So I now create my postgis tables with a CREAT TABLE WITH OIDS
and I use a using unique oid clause in the DATA statement.
As often, details do matter.
On 26/6/09 11:10 PM, Bart van den Eijnden (OSGIS) wrote:
Mapserver needs an integer type column for the USING UNIQUE clause, not
a string column. That won't work.
Actually, no it doesn't require an integer type column for the UNIQUE
clause. I have used text fields in the past with mapserver