Re: '0' vs. blank

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61760
interpreted = N
texte = Use the format context and store the scores as 000 001 002 .... 999 Then lose the scoreTYPE=num, and let it sort alphabetically. Then 0 would not be seen as blank. You can still add them up in math contexts if you like. Terry > > I did this on WebDNA5.1c on a Redhat box. I was trying to do a search >for blank fields in a results database that looks like this: > >IDCOMPETITORSCORE >1Comp10 >2Comp25 >3Comp37 >4Comp49 >5Comp5 > >Comp5 was not in the round, so he didn't score anything. I was using >the code > >[search db=scores.db&neSCOREdata=[blank]&SCOREsort=1&SCOREtype=num] >[founditems]....[/founditems] >[/search] > >What returned was a formatted list of 3 players. WebDNA treated the 0 >as a blank value and passed it over. Searching the archives showed >just a few references to 0 = blank, but no patches. Anyone know about >a patch or a simple way around this? >----------------------------------------- >Steve Dannaway -- -- Terry Wilson | terry@terryfic.com | http://terryfic.com creator of: http://WhosComing.com - a simplified, affordable online reservation system http://WhosBringingWhat.com - online potluck signup sheet -------------------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: '0' vs. blank ( Terry Wilson 2005)
  2. Re: '0' vs. blank ( Gary Krockover 2005)
  3. '0' vs. blank ( Steve Dannaway 2005)
Use the format context and store the scores as 000 001 002 .... 999 Then lose the scoreTYPE=num, and let it sort alphabetically. Then 0 would not be seen as blank. You can still add them up in math contexts if you like. Terry > > I did this on WebDNA5.1c on a Redhat box. I was trying to do a search >for blank fields in a results database that looks like this: > >IDCOMPETITORSCORE >1Comp10 >2Comp25 >3Comp37 >4Comp49 >5Comp5 > >Comp5 was not in the round, so he didn't score anything. I was using >the code > >[search db=scores.db&neSCOREdata=[blank]&SCOREsort=1&SCOREtype=num] >[founditems]....[/founditems] >[/search] > >What returned was a formatted list of 3 players. WebDNA treated the 0 >as a blank value and passed it over. Searching the archives showed >just a few references to 0 = blank, but no patches. Anyone know about >a patch or a simple way around this? >----------------------------------------- >Steve Dannaway -- -- Terry Wilson | terry@terryfic.com | http://terryfic.com creator of: http://WhosComing.com - a simplified, affordable online reservation system http://WhosBringingWhat.com - online potluck signup sheet -------------------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Terry Wilson

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:

reverse loops (1998) Date format problems (1997) Preventing code execution (2003) Which Pref is faster? (1998) [ShowNext] feature in 2.0 (1997) Format of Required fields error message (1997) back button problem (1999) WebCat Stuff (2001) Test .... (2002) [WebDNA] Different responses for the same commands ... (2011) [ShowNext] feature in 2.0 (1997) default value from Lookup (was Grant, please help me) (1997) WCS Newbie question (1997) Pre-flight public flag (1997) Fwd: Image Pirating [protecting against] (2003) WebCat2 - [format thousands] (1997) Cart Question (1998) Exclude by date - multiple (1997) Setting up shop (1997) ShowIf variables (1997)