Wow, slightly stunned that SQL Server 2000 doesn't have that, at least Oracle has ROWNUM...! Thanks for the clarification though :)
Mike On 3/1/2007, "Sean De La Torre" <[EMAIL PROTECTED]> wrote: >Mike, > >Sorry for the confusion. The generic paginated views will not work >correctly because SQL Server 2000 doesn't naively support the limit offset >functionality that other DBs do. I think that SQL Server 2005 does have >that functionality, but so many people still use SQL Server 2000 that a >solution that accommodates both has to be created. > >Thanks, > >Sean > > >On 3/1/07, Mike H <[EMAIL PROTECTED]> wrote: >> >> >> >> On 3/1/2007, "Sean De La Torre" <[EMAIL PROTECTED]> wrote: >> >With the exception of dataset paging, it is feature complete and stable. >> >> Excuse the dumb question, but does that mean that generic paginated views >> will not work, or will just be quite inefficient? >> >> Thanks, >> >> Mike >> >> >> >> >On 3/1/07, Jeremy Dunck <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> On 3/1/07, Fuzzkat <[EMAIL PROTECTED]> wrote: >> >> > >> >> > Our Django app - currently running against version 0.96pre - has a >> >> > business requirement to support Microsoft SQL Server or Oracle. >> >> >> >> There is a branch for Oracle support. After some discussion at PyCon, >> >> it seems there is a plan for getting it merged back to trunk. I'm not >> >> sure when that'll be, but more testers on that branch would help move >> >> it along. In any case, I seriously doubt it'd happen before 0.96. >> >> >> >> >> >> >> http://code.djangoproject.com/browser/django/branches/boulder-oracle-sprint >> >> >> >> > We're on the verge of defecting to Ruby-on-Rails, with it's out of >> the >> >> > box MS-SQL support, as the only SQL Server patch that we have found >> >> > only works against 0.91. >> >> >> >> I don't think MS SQL support will happen without a champion (as >> >> occurred with Oracle). I and several others had a go at it about a >> >> year ago and there has been a good bit of interest in it, but not >> >> enough to actually get it working and get a commitment to maintain the >> >> support going forward. >> >> >> >> There's some hope that Malcolm's effort to refactor QuerySet will help >> >> bring in SQL Server, but it will be well after 0.96 in any case. >> >> >> >> > Has anyone written a working patch against 0.95 or 0.96pre that can >> >> > save our project? >> >> >> >> Sorry. :-/ >> >> >> >> > >> >> >> > >> >> >> >> > >> > >> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
