Well, you can't do a numeric search on non-numeric values. Umm... I think I'd add a field/column to my result set -- using the QueryAddColumn() -- and, for each row, set this new field to the 'housenumber' field's *numeric* equivalent -- using the QuerySetCell() and Val() functions. Then sort on this, now numeric, field in my cf_querysort. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -----Original Message----- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 5:21 PM 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]
