[mapserver-users] Problem using getShape with MsSql2008 (Mapscript C#)

[Paul james]

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/8180148f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: shape_postgis.PNG
Type: image/png
Size: 37468 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090807/8180148f/attachment.png>