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:

I want a 404 (2005) executive server side java within webDNA (1997) WebCat chatroom (1997) Configuring E-mail (1997) [time] math Q (2003) [WebDNA] Double sendmails (2014) Is it possible to pause or wait a process (2000) Exclude by date - multiple (1997) Ampersand is breaking search context (1999) Country & Ship-to address & other fields ? (1997) % (mod) was looping table rows (1999) WCS Newbie question (1997) pc (1997) webdna+post+WinIE6 (2004) HTML Emails To Eudora For Windows (2005) IIS and 4.0.1b1 (2000) strange [date] behavior (2001) emailer w/F2 (1997) Loss in Form (1998) Only charge card when product shipped ? (1997)