I see... it uses current_timestamp...
I'll use getdate() in SQLCE. I'll update the patch shortly.
Diego
On Fri, Jul 23, 2010 at 09:50, Fabio Maulo <[email protected]> wrote:
> have a look to MSSQL dialects
>
>
> On Fri, Jul 23, 2010 at 8:46 AM, Diego Mijelshon
> <[email protected]>wrote:
>
>> The idea crossed my mind... but at that point, the input is a SqlString,
>> so I'd have to know the actual Id column name (i.e. I can't use the
>> pseudo-property).
>> One possibility is finding the first member after the SELECT clause, which
>> should be the Id in non-projection queries. It might be a good compromise.
>> Thoughts?
>>
>> Diego
>>
>>
>>
>> On Fri, Jul 23, 2010 at 03:19, Ayende Rahien <[email protected]> wrote:
>>
>>> You can check it if has OrderBy and add Order By id?
>>>
>>>
>>> On Fri, Jul 23, 2010 at 12:22 AM, Diego Mijelshon <
>>> [email protected]> wrote:
>>>
>>>> Hi all,
>>>>
>>>> I've just created http://216.121.112.228/browse/NH-2252, to support the
>>>> new paging syntax (if only the full SqlServer supported it...)
>>>>
>>>> It's kinda trivial, but I have one concern...
>>>>
>>>> This syntax is only valid when there is an ORDER BY clause (which makes
>>>> sense).
>>>> SQLCE has a decent error message for it: "OFFSET clause is invalid
>>>> unless ORDER BY clause is specified."
>>>>
>>>> Should we leave that as-is?
>>>>
>>>> Diego
>>>>
>>>
>>>
>>
>
>
> --
> Fabio Maulo
>
>
