searching for not-a-number
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54751
interpreted = N
texte = Is there a way to specify "not a number" in a search? I'd like to be able to allow users to put arbritrary strings as labels in a file where that same column will hold ID numbers. For example, they might upload a file that looks like this: idno test1 test2 test3 max 100 100 100 12345657 78 98 56 22345667 34 23 46 .... Where "max" is a label that will be used to add a row to a table that is constructed according to the number of columns and label rows in the uploaded file. Typical labels would be "mean", "median" and "max", but I'd like to not have to hard-code searches and miss a novel label, or have to modify the code each time someone wants a different label. The strategy I use now is search for idno=max, idno=mean, etc. and set a flag that is then used to either construct that row or not: [ShowIf [mean]=1] [raw][Search [/raw]db=[theName][raw]&eqIDNOdataRQ=mean][/raw] [raw][text]found=[numFound][/text][/raw] [raw][FoundItems][/raw]
| Mean | [Search table=temp&neFNdataRQ=[blank]&fnSort=1] [FoundItems] [[fn]] | [/FoundItems] [/Search]
[raw][/FoundItems][/raw] [raw][/Search][/raw] [/ShowIf] Thanks! Dave Hurley Department of Biology University of Washington ------------------------------------------------------------- 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:
Is there a way to specify "not a number" in a search? I'd like to be able to allow users to put arbritrary strings as labels in a file where that same column will hold ID numbers. For example, they might upload a file that looks like this: idno test1 test2 test3 max 100 100 100 12345657 78 98 56 22345667 34 23 46 .... Where "max" is a label that will be used to add a row to a table that is constructed according to the number of columns and label rows in the uploaded file. Typical labels would be "mean", "median" and "max", but I'd like to not have to hard-code searches and miss a novel label, or have to modify the code each time someone wants a different label. The strategy I use now is search for idno=max, idno=mean, etc. and set a flag that is then used to either construct that row or not: [ShowIf [mean]=1] [raw][Search [/raw]db=[theName][raw]&eqIDNOdataRQ=mean][/raw] [raw][text]found=[numFound][/text][/raw] [raw][founditems][/raw] | Mean | [Search table=temp&neFNdataRQ=[blank]&fnSort=1] [founditems] [[fn]] | [/FoundItems] [/Search]
[raw][/FoundItems][/raw] [raw][/Search][/raw] [/ShowIf] Thanks! Dave Hurley Department of Biology University of Washington ------------------------------------------------------------- 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/
Dave Hurley
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:
Use of & in text areas.... (1998)
New public beta available (1997)
Sample Tearoom Search Error (1998)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
show all problem (1997)
RE: Web*SSL and WebCatalog (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Tiny feature request (2000)
Changes to [ReturnRaw] in 3.0 (1998)
[url] (1997)
Truncated Sendmail (1998)
Text data with spaces in them... (1997)
WebDNA 6 (2004)
Random Images (2000)
WCf2 and nested tags (1997)
[WebDNA] Mailing list failure !!! (2019)
WebCat2b13MacPlugIn - More limits on [include] (1997)
notification solutions (1997)
WebCat2 beta FTP site (1997)
TXT (2003)