fieldType=num

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11491
interpreted = N
texte = I always wondered what would happen when a field was defined as type=num and sorted in ascending order ... but one or more of the retrieved records has text data in that field ...Well, I just tried it, and it looks like the records with text data in that field are pushed to the top of the list of retrieved records ... just in case anyone else is curious about this ... :)Sincerely, Ken Grome ..... ken@iav.com http://usarea.net/home.html Associated Messages, from the most recent to the oldest:

    
  1. fieldType=num (Kenneth Grome 1997)
I always wondered what would happen when a field was defined as type=num and sorted in ascending order ... but one or more of the retrieved records has text data in that field ...Well, I just tried it, and it looks like the records with text data in that field are pushed to the top of the list of retrieved records ... just in case anyone else is curious about this ... :)Sincerely, Ken Grome ..... ken@iav.com http://usarea.net/home.html Kenneth Grome

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

$Quit, $CloseDatabase corrections (1997) Bug with convertchars crashes WebCat!! (1999) delete fails (2000) Math with Time (1997) Country & Ship-to address & other fields ? (1997) Am I being really stupid? (2003) grep is really pathetic sometimes (2003) latest version? (1998) Validation (2000) Math (1997) Character limit in [Search]? (1998) OFF-TOPIC: Check www.godaddy.com for me ... (2003) Math function in Formula.db (1997) Search Question (1998) Formulas and Multiple Prices (2000) [WriteFile] problems (1997) webmerch and serials - almost there (1997) Reversed words (1997) PCS Frames (1997) Re2: frames & carts (1997)