Problem with order by in aspx page
-
Hi I have a query which is ran from my aspx page. The query is ordered by a field which contains the letters 'y' and 'n' Now when the letter is not a capital it orders fine, but when the letter is a capital it doesnt order properly. Why is this? any help would do. thanks
-
Hi I have a query which is ran from my aspx page. The query is ordered by a field which contains the letters 'y' and 'n' Now when the letter is not a capital it orders fine, but when the letter is a capital it doesnt order properly. Why is this? any help would do. thanks
always make it to same case, means either Upper case or Lower case before you order by in the query.
Abhishek Sur
-
always make it to same case, means either Upper case or Lower case before you order by in the query.
Abhishek Sur
-
Hi I have a query which is ran from my aspx page. The query is ordered by a field which contains the letters 'y' and 'n' Now when the letter is not a capital it orders fine, but when the letter is a capital it doesnt order properly. Why is this? any help would do. thanks
-
Do you mean in the query? How would I do this? Or do you mean manually change all data? That would be an extreme solution!
Yes.. Its in query... no need to do this manually... But if you like in code ... this would not be a big deal. Have you used LINQ. ..
Abhishek Sur