ay 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 t
TED]>
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 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-
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 so
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
5 matches
Mail list logo