Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-28 Thread CF-Talk
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

Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-28 Thread CF-Talk
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

RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-27 Thread Peter J. MacDonald
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-

RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-27 Thread mherbene
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

RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-27 Thread Courtney Payne
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