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

[Tamas Szekeres]

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.html