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: idnotest1test2test3 max100100100 12345657789856 22345667342346 .... 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:

    
  1. Re: searching for not-a-number - solved ( Dave Hurley 2003)
  2. searching for not-a-number ( Dave Hurley 2003)
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: idnotest1test2test3 max100100100 12345657789856 22345667342346 .... 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:

Re:my First Ship table (1998) in string ??? (2001) Pithy questions on webcommerce & siteedit (1997) LOOP and IF statements (1997) strip .0 off off IPaddress (1998) Filemaker & WebCat (2001) WebCatalog f2 Installation (1997) How To question on setting up downloads (1997) Help with Search (2004) 403 Forbidden Errors (2003) Strange ThisURL under Linux (2000) WebCat2b13 Command Reference Doc error (1997) Searching for foreign chars (2004) trouble updating records in database (1998) Bad Cookie / Internet Option / Internet Explorer (2004) Separate SSL Server (1997) Wireless WebDNA available today! (2000) two unique banners on one page (1997) Encrypting WebDNA Templates (1999) WebDNA Server Not Running (2005)