Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
Peter, thank you. This is probably it. I was thinking this is the reason for the error as well. I probably have to add another column additionally to the housenumber field which is taking the additions like "A" or "B" or "-" so that the values in the field itself stay as numeric/text values. Uwe - Original Message - From: "Peter J. MacDonald" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Freitag, 27. Oktober 2000 23:37 Subject: RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !) 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
Courtney, I don't want to do a search. I want to do a sort. The sort in a numeric way over a varchar field is possible with this Tag. But I will try what you supposed on taking QueryAddColumn() Thanks. Uwe - Original Message - From: "Courtney Payne" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Freitag, 27. Oktober 2000 14:14 Subject: RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !) 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
You might see if one of the other sort tags available at allaire would handle your content. -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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
