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:

Extended [ConvertChars] (1997) WebCommerce: Folder organization ? (1997) database confused (2000) Weird Math and SV (1997) totals (1997) Here we go again... was: DDEConnect not working (2006) WebCat2 several catalogs? (1997) More on the email templates (1997) Refering page (1998) contextual shownext (1998) FlushDatabases (2000) Simple way to create unique SKU (1997) (thx) automating a POST (2002) Can this be done? (1997) [WebDNA] copy some database fields into a new database (2016) quantity limit (1998) No messages for a week? (2000) ShowNext Command (1997) WebTen and WebCat (1997) RE: [BULK] RE: [WebDNA] [BULK] Webdna 6.2 and Windows Server 2012 (2020)