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 as000001002....999Then 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.comcreator 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:
Use the format context and store the scores as000001002....999Then 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.comcreator 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)