Hi,

I am using ASP.NET and Oracle, as database, to develop/migrate a reporting application,. In couple of places, I used dataview sorting of the resultset, returned from Oracle. But I got some ordering problem, after sorting. I am getting records, of columns used in order by clause, having null values at the TOP of sorted resultset. But when I directly query the oracle database with order by clause, I am getting a all the records with null values at the bottom.

Now my question is: How do I get records with null values, of the columns used in order by clause, at the bottom using dataview sort as it is retured from Oracle direct query?

Thanks,
Ajay

---

There are quite a few differences between Oracle and SQL Server, which makes
it a pain to use Oracle in .NET, at times. If the result set is not large,
instead of using DataGrid sorting, write your own that has Oracle sort the
data for you. For proper encapsulation, you can have a routine that helps
with the query or calls the sproc in the right manner.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
[quoted text, click to view]
application,. In couple of places, I used dataview sorting of the resultset,
returned from Oracle. But I got some ordering problem, after sorting. I am
getting records, of columns used in order by clause, having null values at
the TOP of sorted resultset. But when I directly query the oracle database
with order by clause, I am getting a all the records with null values at the
bottom.
[quoted text, click to view]
used in order by clause, at the bottom using dataview sort as it is retured
from Oracle direct query?
[quoted text, click to view]
Community Website: http://www.dotnetjunkies.com/newsgroups/