Re: search comparison

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50194
interpreted = N
texte = You can to use a second field of selection :[If ([RSCH]=) | ([RSCH]=[Raw][RSCH][/Raw])][Then] [Text]vtSEARCH=neIDdatarq=[/Text] [Text]RSCH=[/Text] [/Then][Else] [Text] vtSEARCH =group1field=ID+Name+Address+ZIP+Town&waGROUP1datarq=[RSCH][/Text] [/Else][/If][If ([RSCH2]=) | ([RSCH2]=[Raw][RSCH2][/Raw])][Then] [Text] vtSEARCH =[vtSEARCH]&neCATEGORIESdatarq=[/Text] [Text]RSCH2=All[/Text] [/Then][Else] [Text] vtSEARCH =[vtSEARCH]&eqCATEGORIESdatarq=[RSCH2][/Text] [/Else][/If]
Search :
All
Red
Blue
[Search db=Database.db&[vtSEARCH]&NAMEsort=1]Le vendredi, 9 mai 2003, à 22:59 Europe/Paris, kmac a écrit :> Sorry, just need to ad > to my quick search form. > > On Friday, May 9, 2003, at 02:53 pm, kmac wrote: > >> Hi group, what is the best way to eliminate one category only when I >> do a search? I want the user to be able to use a check box to flag >> out only one particular category. >> >> When I use: >> [search db=sparchive.db&[search_string][showif >> [adv]=T]&neCategoriesdata=Advertising[/showif]&...] >> bssbgsfg..... >> [/search] >> >> It ignores the specific search and gives me everything but [adv]. >> >> I'm obviously overlooking something simple. >> >> TIA >> Ken M >> >> >> ------------------------------------------------------------- >> 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/ >> > > ------------------------------------------------------------- > 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/ > > ------------------------------------------------------------- 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: [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
  2. Re: [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
  3. Re: [WebDNA] Search comparisons in 8.6.1 (Stuart Tremain 2019)
  4. [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
  5. Re: [WebDNA] search comparison: ends with (Donovan Brooke 2016)
  6. Re: [WebDNA] search comparison: ends with (Lawrence Banahan 2016)
  7. Re: [WebDNA] search comparison: ends with (Matthew Bohne 2016)
  8. Re: [WebDNA] search comparison: ends with (Iphonzie 2016)
  9. Re: [WebDNA] search comparison: ends with (Kenneth Grome 2016)
  10. Re: [WebDNA] search comparison: ends with (christophe.billiottet@webdna.us 2016)
  11. Re: [WebDNA] search comparison: ends with (christophe.billiottet@webdna.us 2016)
  12. [WebDNA] search comparison: ends with (Kenneth Grome 2016)
  13. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  14. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
  15. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  16. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
  17. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  18. [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
  19. Re: search comparison (Laurent Bache 2003)
  20. Re: search comparison (Laurent Bache 2003)
  21. Re: search comparison (kmac 2003)
  22. search comparison (kmac 2003)
  23. How to *require* a 'cl' search comparison (amongst other required comparisons) (John Butler 2000)
  24. question on *requiring* a 'cl' search comparison (amongst other required comparisons) (John Butler 2000)
  25. Re: format search comparison Q (Steven Jarvis 2000)
  26. Re: format search comparison Q (WebDNA Support 2000)
  27. Re: format search comparison Q (Steven Jarvis 2000)
  28. Re: format search comparison Q (WebDNA Support 2000)
  29. format search comparison Q (Steven Jarvis 2000)
  30. search comparison problem (Steven Jarvis 2000)
You can to use a second field of selection :[If ([RSCH]=) | ([RSCH]=[raw][RSCH][/Raw])][Then] [text]vtSEARCH=neIDdatarq=[/Text] [text]RSCH=[/Text] [/Then][Else] [text] vtSEARCH =group1field=ID+Name+Address+ZIP+Town&waGROUP1datarq=[RSCH][/Text] [/Else][/If][If ([RSCH2]=) | ([RSCH2]=[raw][RSCH2][/Raw])][Then] [text] vtSEARCH =[vtSEARCH]&neCATEGORIESdatarq=[/Text] [text]RSCH2=All[/Text] [/Then][Else] [text] vtSEARCH =[vtSEARCH]&eqCATEGORIESdatarq=[RSCH2][/Text] [/Else][/If]
Search :
All
Red
Blue
[Search db=Database.db&[vtSEARCH]&NAMEsort=1]Le vendredi, 9 mai 2003, à 22:59 Europe/Paris, kmac a écrit :> Sorry, just need to ad > to my quick search form. > > On Friday, May 9, 2003, at 02:53 pm, kmac wrote: > >> Hi group, what is the best way to eliminate one category only when I >> do a search? I want the user to be able to use a check box to flag >> out only one particular category. >> >> When I use: >> [search db=sparchive.db&[search_string][showif >> [adv]=T]&neCategoriesdata=Advertising[/showif]&...] >> bssbgsfg..... >> [/search] >> >> It ignores the specific search and gives me everything but [adv]. >> >> I'm obviously overlooking something simple. >> >> TIA >> Ken M >> >> >> ------------------------------------------------------------- >> 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/ >> > > ------------------------------------------------------------- > 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/ > > ------------------------------------------------------------- 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/ Laurent Bache

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:2nd WebCatalog2 Feature Request (1996) [WebDNA] [OT] the "Work in progress" thread. (2009) sandboxes with 6.0 (2004) two of the same named db's open at once (1998) really wierd browser truncating (1997) Occasional crashes with $remove (1997) Error -108 (1997) Error Lob.db records error message not name (1997) Help!!!! (1997) re: [WebDNA] sales tax on shipping (2008) FREE Web Server Monitor FREE (1997) Can you do this??? and other stuff (1997) Searching multiple fields (1997) NT Manual (1997) WebCatalog can't find database (1997) Oops, Sorry for the cluttter ... Looking for WebCatdeveloper/contractor (2000) emailer (1997) WebCat b13 CGI -shownext- (1997) Unsubscribe (2001) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)