[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server

[Afroz Kannancheri]

Dear Tamas,
 Heres the debug log obtained when i clicked on the polygon 

[Tue Mar 02 12:28:47 2010].113000 msMSSQL2008LayerOpen called datastatement:
geom from region1 USING UNIQUE id USING SRID=4326
[Tue Mar 02 12:28:47 2010].113000 MSMSSQL2008LayerOpen -- shared connection
not available.
[Tue Mar 02 12:28:47 2010].957000
msConnPoolRegister(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
Security=false,01E39FC0)
[Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerParseData: unique column =
id, srid='4326', geom_column_name = geom, table_name=region1
[Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerFreeItemInfo called
[Tue Mar 02 12:28:47 2010].957000 in msMSSQL2008LayerGetItems  (find column
names)
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerWhichShapes called
[Tue Mar 02 12:28:48 2010].113000 query_string_temp:SELECT
convert(varchar(max), ID),convert(varchar(max), name),convert(varchar(max),
flag1),convert(varchar(max), flag2),convert(varchar(max),
flag3),geom.STAsBinary(),convert(varchar(20), id) from region1 WHERE
geom.STIntersects(Geometry::STGeomFromText('POLYGON((55.4843749962207
-4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545
-3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207
-4.59960928778372))',4326)) = 1 
[Tue Mar 02 12:28:48 2010].394000 msMSSQL2008LayerClose datastatement: geom
from region1 USING UNIQUE id USING SRID=4326
[Tue Mar 02 12:28:48 2010].394000
msConnPoolRelease(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
Security=false,01E39FC0)
[Tue Mar 02 12:28:48 2010].394000
msConnPoolClose(server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
Security=false,01E39FC0)
[Tue Mar 02 12:28:48 2010].410000 freeLayer(): freeing layer at 01E15180.

Thnx
Afroz
-- 
View this message in context: http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.html
Sent from the Mapserver - User mailing list archive at Nabble.com.