2008/10/16 BrainDrain <[EMAIL PROTECTED]>: > -without "WITH(INDEX..." in mapfile data section - mem corruption exception > on "shape = layer.getFeature(featureIndexe, -1)" after successful execution > of queryByPoint (querying the largest polygon in my geodb);
I didn't encounter any memory corruption error here, could you provide an example to this? I've set up your database with IIS and apache with the following links: http://vbkto.dyndns.org:1280/cgi-bin/mapserv.exe?mode=map&map=test2008.map http://vbkto.dyndns.org:1080/cgi-bin/mapserv.exe?mode=map&map=test2008.map > -with using "WITH(INDEX...": > msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL > statement: select convert(varchar(max), STATUS),convert(varchar(max), > STAGE),convert(varchar(max), id),GEOM from dbo.Construct > WITH(INDEX(SIndx_Construct_geometry_geom)) where id = 190748 > -[Microsoft][ODBC SQL Server Driver][SQL Server]Query processor could not > produce a query plan because of the hints defined in this query. Resubmit > the query without specifying any hints and without using SET FORCEPLAN. > When I'm trying to execute this select statement in man. studio - error > message - the same. > I think because where clause don't contains conditions related to spatial > index used in 'WITH' hint. You're right, just looking into the code here is a possible solution: DATA "GEOM from dbo.Construct USING UNIQUE id USING SRID=0 USING INDEX SIndx_Construct_geometry_geom" Best regards, Tamas _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
