[mapserver-users] Problem using getShape with MsSql2008 (Mapscript C#)
Tamas Szekeres
szekerest at gmail.com
Fri Aug 7 07:57:11 PDT 2009
Another issue coul be that the layer type is not compatible with the
geometry type, like the following combinations are invalid with this driver:
Layer type shape geom type
line point
polygon point
polygon line
I'd also be curious about the wkb of your geometry
Could you dump your related feature table in the SQL management studio
query analyzer?
select * from [table] where [id]=10
or something like this...
Best regards,
Tamas
2009/8/7 Paul james <pauljame at gmail.com>
> Yes.... But the same code with a Postgis db is ok...
> Image attached
>
> Paul
>
>
> On Fri, Aug 7, 2009 at 11:21 AM, Tamas Szekeres <szekerest at gmail.com>wrote:
>
>> This appears to be a null shape with no valid geometry. (type=3, numlines
>> = 0)
>>
>> Best regards,
>>
>> Tamas
>>
>>
>>
>> 2009/8/7 Paul james <pauljame at gmail.com>
>>
>> The layer geometry is fine...
>>> I´m sending a shape property screenshot...
>>>
>>> Paul
>>>
>>>
>>> On Fri, Aug 7, 2009 at 5:25 AM, Tamas Szekeres <szekerest at gmail.com>wrote:
>>>
>>>> Paul,
>>>>
>>>> There is a function (find_bounds) calculating the bounds in
>>>> mapmssql2008.c which should provide correct results.
>>>> Could you check whether the returned geometry is correct by dumping the
>>>> point coordinates of each lines in mapscript?
>>>>
>>>> Best regards,
>>>>
>>>> Tamas
>>>>
>>>>
>>>> 2009/8/6 Paul james <pauljame at gmail.com>
>>>>
>>>> Just an update...
>>>>> The shape values are all there... The only thing is wrong is the bounds
>>>>> (-1) ...
>>>>>
>>>>>
>>>>> On Wed, Aug 5, 2009 at 5:44 PM, Paul james <pauljame at gmail.com> wrote:
>>>>>
>>>>>> I´ll check...
>>>>>> But the same layer/id worked fine using Postgis... So I should be a
>>>>>> bug...
>>>>>>
>>>>>> Paul
>>>>>>
>>>>>>
>>>>>> On Wed, Aug 5, 2009 at 5:38 PM, Tamas Szekeres <szekerest at gmail.com>wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I think you should check the sql statement submitted by the driver by
>>>>>>> using the SQL Profiler. I suspect no records have been retrieved during the
>>>>>>> fetch.
>>>>>>>
>>>>>>> Best regards,
>>>>>>>
>>>>>>> Tamas
>>>>>>>
>>>>>>>
>>>>>>> 2009/8/5 Paul james <pauljame at gmail.com>
>>>>>>>
>>>>>>>> Hello guys...
>>>>>>>> That code is working fine with Postgis:
>>>>>>>>
>>>>>>>> _layer.open();
>>>>>>>> var _shape = new shapeObj((int)_layer.type);
>>>>>>>> _layer.getShape(_shape, 0, __id.ToInt32());
>>>>>>>>
>>>>>>>> The _shape.bounds are all -1 using MsSql2008 ...
>>>>>>>>
>>>>>>>> Any idea?
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> mapserver-users mailing list
>>>>>>>> mapserver-users at lists.osgeo.org
>>>>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090807/c21ab6fd/attachment.htm>
More information about the MapServer-users
mailing list