"Geometry expressions cannot be used in the ORDER BY specification (near '%1')"
| Item | Description |
|---|---|
|
SQLCode |
-1531L |
|
Constant |
SLERR_GEOM_ORDER_BY |
|
SQLState |
2FW92 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
3186 |
|
Severity Code |
|
|
Parameter 1 |
The geometry expression. |
Geometry expressions cannot be used in the ORDER BY clause. The ST_LinearHash() method may be used in the ORDER BY specification to order geometry values using the same rules used for spatial indexes, or a conversion method such as ST_AsText() may be used to order the rows by their string representation.