The reason is that 93-94 and 101B can not be turned into numbers. The tag
is probably suppose to take VARCHAR columns and make them into numeric
columns only if the value of the column is a number(i.e. no A-Z or special
characters.
Pete
-----Original Message-----
From: CF-Talk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 17:21
To: CF-Talk
Subject: CF_QuerySort-problem (Was: SQL-SORT-Problem
in a query !)
o.k.
I had a sorting problem yesterday but with the help of the
Custom Tag
CF_QuerySort
I am able to sort a varchar-column in a numeric way. (This
morning I thought
at least !)
Although right now it doesn't seem to work anymore, since in
my housenumber
field there
are most likely values like 93-94 and 101B and so on. I
don't know why
exactly but he (CF) is telling me
nonstop when I order via the housenumber-field in a numeric
manner the
following:
-----------------------------------------------------------------------
Error Diagnostic Information
In function ArraySort the array element at position 4 is not
a numeric value
The error occurred while evaluating the expression:
Temp = ArraySort(MyArray, Attributes.SortType,
Attributes.SortOrder)
The error occurred while processing an element with a
general identifier of
(CFSET), occupying document position (39:1) to (39:76).
-----------------------------------------------------------------------
Ideas why ?
Uwe
SD Solutions
Lange Zeile 27
85435 Erding
Fon: 08122/903791
Fax: 08122/903792
Mail: [EMAIL PROTECTED]
Web: www.sdsolutions.de
----------------------------------------------------------------------------
--------------------
Archives:
http://www.mail-archive.com/[email protected]/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
