ODBC and WKT

Jeppe Lund Andersen JXA at COWI.DK
Wed Nov 15 04:18:20 EST 2006


Hello

Iam running on a windows 2003 server and mapserver 4.8.1 and php 4.4.2
Iam using a ODBC connection ( "ODBC:test/test at test_dns,v_aktiveflader" )

In The view It has a coln named "WKT" in there I have this string
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))

When I use "$Layer->queryByAttributes($ID_navn, $ID_value, $ResultType);" to get the specifik shape 
it returns 0
if I change the WKT streng to 

POLYGON((501982.449393967 6268525.27980791, 501972.653330944 6268522.51037162, 501956.796572362 6268519.5209801))

It works fine.

So is there a limit to how long the WKT string can be ?
or a work around so I can load long WKT strings



Med venlig hilsen
 
Jeppe Lund Andersen
COWI A/S

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061115/209ddd60/attachment.html


More information about the mapserver-users mailing list