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:

Upgrading old WebCat Database Files (1997) WebCat2: Items xx to xx shown, etc. (1997) grouped fields? (1999) in header include files? (1998) authenticate (2002) Adding up weights (1998) problems with 2 tags shakur (1997) Looking for WebDNA calendar (2004) [showif],[refferer],[include] in errormessages.db (2002) Document Contains No Data! (1997) Checking for blank form fields 2nd idea (1998) Combining search criteria in a context? (1998) New site announcement + Showing once on a founditems (1997) Mac & Internet Explorer, and # of orders/traffic (2000) WCS Newbie question (1997) Webcatalog, Webstar and Crasharama (1999) Decrypting a user password (2000) Cannot get subtotal to work (1997) ShipToState question (1998) Shownext never shows next...still (1997)