|
From: <sv...@de...> - 2005-06-21 02:07:10
|
Author: marcelo
Date: 2005-06-20 22:07:14 -0400 (Mon, 20 Jun 2005)
New Revision: 1376
Modified:
humano2/trunk/components/viewTools/ViewTools.cs
Log:
FIXED: ticket #211, sorting based on a text field
Modified: humano2/trunk/components/viewTools/ViewTools.cs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/components/viewTools/ViewTools.cs 2005-06-21 01:13:30 U=
TC (rev 1375)
+++ humano2/trunk/components/viewTools/ViewTools.cs 2005-06-21 02:07:14 U=
TC (rev 1376)
@@ -928,17 +928,22 @@
{
order.Append("upper(" + tableName + "." + columnName + ") ");
=20
- parameter =3D parameters[1].ToString();
- if(parameter =3D=3D "0")
- {
- order.Append("asc ");
- }
- else
- {
- order.Append("desc ");
- }
- order.Append(", ");
}
+ else
+ { //Obtain the first 50 chars to sort.
+ order.Append("substring(upper(" + tableName + "." + columnName + ")=
,0,50) ");
+
+ }
+ parameter =3D parameters[1].ToString();
+ if(parameter =3D=3D "0")
+ {
+ order.Append("asc ");
+ }
+ else
+ {
+ order.Append("desc ");
+ }
+ order.Append(", ");
}
order.Remove(order.Length-2,2);
order.Append(" ");
|