This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello, is there anyway to order the limiting of records and the distinction of records? E.g. I do a query.Page = Page.Limit(20); and I also have a query.Distinct = true; however I don't get back 20 records from the DB only 3 since the distinct is applied after the limit. Thanks, Craig |
|
|
Hi Craig :) Just having a look at this, can you confirm which provider you are using? My assumption would be SqlServer2005.
Jeremy |
|
|
Yes it is SQL 2005. It is not urgent, I have another work around that is actually better but I was just interested in the concept of it as I thought it was important. Craig |
|