<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.5">
<TITLE>ODBC and WKT</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hello</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Iam running on a windows 2003 server and mapserver 4.8.1 and php 4.4.2</FONT>
<BR><FONT SIZE=2 FACE="Arial">Iam using a ODBC connection ( "ODBC:test/test@test_dns,v_aktiveflader" )</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">In The view It has a coln named "WKT" in there I have this string<BR>
</FONT><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">POLYGON((501982.449393967 6268525.27980791, 501972.653330944 6268522.51037162, 501956.796572362 6268519.5209801, 501940.618225853 6268518.84111849, 501932.908361437 6268518.52118361, 501932.900115592 6268518.52118361, 501929.131764749 6268520.48078474, 501910.570369239 6268517.73134438, 501901.491694669 6268517.99129147, 501885.973015703 6268521.24063007, 501869.547293866 6268527.49935613, 501860.781961379 6268530.53873747, 501845.807508137 6268537.24737195, 501831.822556211 6268543.60607765, 501819.099218463 6268550.38469788, 501808.932092445 6268556.32348906, 501797.899152777 6268563.95193631, 501790.469647067 6268569.21086587, 501778.010176335 6268579.64874127, 501770.349786984 6268586.4273615, 501766.878286536 6268590.09661464, 501761.254620726 6268598.89482379, 501757.939791319 6268605.50347861, 501757.651186768 6268607.74302276, 501757.214157021 6268607.94298206, 501757.057485979 6268612.22211106, 501756.942044159 6268612.63202762, 501756.958535847 6268612.63202762, 501754.905320618 6268620.93033852, 501789.471899907 6268673.55962598, 501805.139004069 6268697.4247683, 501805.163741602 6268697.46476016, 501813.541519407 6268710.24215936, 501813.558011096 6268710.27215325, 501854.226515164 6268772.26953387, 501870.775924666 6268778.71822125, 501870.792416354 6268778.72821922, 501912.359717451 6268804.42298912, 501912.458667582 6268804.48297691, 501925.338676373 6268746.9346907, 501946.439791926 6268678.86854537, 501964.819778862 6268619.43064378, 501975.357967873 6268600.87442085, 501975.21778852 6268600.56448393, 502008.877324936 6268540.03680417, 502013.536226963 6268534.08801503, 502013.577456185 6268534.05802113, 501982.449393967 6268525.27980791))</FONT></P>
<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">When I use "$Layer->queryByAttributes($ID_navn, $ID_value, $ResultType);" to get the specifik shape<BR>
it returns 0<BR>
if I change the WKT streng to </FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">POLYGON((501982.449393967 6268525.27980791, 501972.653330944 6268522.51037162, 501956.796572362 6268519.5209801))<BR>
<BR>
</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">It works fine.</FONT>
</P>
<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">So is there a limit to how long the WKT string can be ?</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">or a work around so I can load long WKT strings</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">Med venlig hilsen</FONT>
<BR><FONT FACE="Arial"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">Jeppe Lund Andersen</FONT>
<BR><FONT SIZE=2 FACE="Arial">COWI A/S</FONT>
</P>
</BODY>
</HTML>