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:

4.0.2b4 (2000) NetSplat and WebCat2 (1997) Triggers, again (2000) SKU lookup (1997) Version 4? (2000) Format question WC Mac f3 (1997) WEBDNA-MAMP (Mac OSX 10.3.9) (2006) Search group and ww (FYI) (2003) Emailer (1997) Still can't upgrade users.db to 2.1.1 (1998) When to use [convertchars] ?!?!? (2000) Database Changes (2000) Banners (1997) Adding Items to Cart (2003) Simple way to create unique SKU (1997) Netscape Cache and Linux (2001) Error Log.db --however (1997) WebCatalog seems to choke on large (2meg) html files. (1998) show all problem (1997) Help! WebCat2 bug (1997)