Viewing 4 posts - 1 through 4 (of 4 total)
RBarryYoung (5/13/2009)
Nish (5/13/2009)
To sort on Jobcount , i have to write "(ORDER BY j.JobCount)" , but as you said datatable does not know the table prifix,...
May 13, 2009 at 3:55 pm
Florian Reischl (5/13/2009)
Nish (5/13/2009)
the order by column and page numbers come from UI(ASP.NET), so it'll only send column name i.e "JobCount"...
May 13, 2009 at 2:49 pm
Ray Laubert (5/13/2009)
Create a view with out the order by. Then select from the view and order by the results. That should work.
I've heard that views are not...
May 13, 2009 at 2:23 pm
this solves the problem, but it seems there's another one.
the order by column and page numbers come from UI(ASP.NET), so it'll only send column name i.e "JobCount" , but in...
May 13, 2009 at 2:21 pm
Viewing 4 posts - 1 through 4 (of 4 total)