[H2-commits] r1376 - humano2/trunk/components/viewTools

[<sv...@de...>]

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(" ");