[fdo-users] Select "TOP" or "rownum < "

Jason Birch jason at jasonbirch.com
Thu Nov 19 21:03:12 EST 2009


Although I would love to see full paging support
(http://trac.osgeo.org/fdo/ticket/79), having support for just TOP X
would be great too.

Jason

On 2009-11-19, Crispin_at_1Spatial <crispin.hoult at 1spatial.com> wrote:
>
> It may work through FDO direct SQL .  It is a MapGuide layer that I am
> trying
> to "protect".
>
> Though something like a GetLimit(1000) capabilities that is exposed and
> translated to native SQL would be perfect I am not sure at what provider
> level this would need to be created at to enable me to apply this on a
> MapGuide layer level.
>
>
>
> Jackie Ng wrote:
>>
>> Shouldn't this work through raw SQL? Most RDBMS FDO providers should
>> support raw SQL.
>>
>> This would be a good extension for the FdoISelect interface. Something
>> like a SetLimit()/GetLimit() property, with matching capabilities to
>> determine if this property is usable.
>>
>> - Jackie
>>
>>
>> Crispin_at_1Spatial wrote:
>>>
>>> Hi,
>>>
>>> I cannot apply a "rownum < 100" to KingOracle (well, not through
>>> MapGuide) as it is interpreted a column name.
>>>
>>> Any suggestions as how to do this?  I want the query to be optimised at
>>> the database and not have to truncate a stream of features with my own
>>> count?
>>>
>>> Because of the different interpretations "SELECT TOP" in SQLServer and
>>> "rownum < " in Oracle it seems like an obvious candidate for an FDO
>>> function/expression (not sure which terminology is right here) that can
>>> be published by providers and interpreted appropriately.
>>>
>>>  Crispin
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://n2.nabble.com/Select-TOP-or-rownum-tp4031693p4033042.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>


More information about the fdo-users mailing list