Re: [WebDNA] SEARCH question

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107794
interpreted = N
texte = This is a multi-part message in MIME format. --------------080606090008050105000806 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello Stuart, Group search should do it:* http://www.webdna.us/page.dna?numero=69 group1field*=ORDERSTATUS&*group2field*=ORDERSTATUS&*group3field*=ORDERSTATUS negroup1data=5&negroup2data=6&negroup3data=12&ALLREQ=T Regards, Steve Stuart Tremain wrote: > I want to search a db and find records where ORDERSTATUS does not > equal 5 or 6 or 12 > > Can this be done in one search ? > > Or will I have to do a > > [HideIf |6|5|12|^|[ORDERSTATUS]|]===== hide record =====[/HideIf] > > > > Regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > --------------------------------------------------------- This message > is sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us -- --------------080606090008050105000806 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 
 Hello Stuart,Group search should do it:http://www.webdna.us/page.dna?numero=69group1field=ORDERSTATUS&group2field=ORDERSTATUS&group3field=ORDERSTATUSnegroup1data=5&negroup2data=6&negroup3data=12&ALLREQ=TRegards,Steve


Stuart Tremain wrote:
I want to search a db and find records where ORDERSTATUS does not equal 5 or 6 or 12

Can this be done in one search ?

Or will I have to do a 

[HideIf |6|5|12|^|[ORDERSTATUS]|]===== hide record =====[/HideIf]



Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au




--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us 
--
--------------080606090008050105000806-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search question (frank@cwolfe.com 2013)
  2. Re: [WebDNA] Search question ("Terry Wilson" 2013)
  3. RE: [WebDNA] Search question ("Terry Nair" 2013)
  4. Re: [WebDNA] Search question (Lawrence Banahan 2013)
  5. [WebDNA] Search question (frank@cwolfe.com 2013)
  6. Re: [WebDNA] Search question (Steve Craig 2012)
  7. Re: [WebDNA] Search question (Toby Cox 2012)
  8. Re: [WebDNA] Search question (Steve Craig 2012)
  9. Re: [WebDNA] Search question (Steve Craig 2012)
  10. Re: [WebDNA] Search question (Toby Cox 2012)
  11. [WebDNA] Search question (Steve Craig 2012)
  12. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  13. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  14. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  15. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Kenneth Grome 2011)
  16. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  18. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  20. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  21. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  22. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  23. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  24. Re: [WebDNA] SEARCH question (Kenneth Grome 2011)
  25. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  26. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  27. Re: [WebDNA] SEARCH question (Govinda 2011)
  28. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  29. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  31. Re: [WebDNA] SEARCH question (Steve Raslevich 2011)
  32. [WebDNA] SEARCH question (Stuart Tremain 2011)
  33. Re: [WebDNA] Search Question (Tony Miller 2009)
  34. Re: [WebDNA] Search Question (John Butler 2009)
  35. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  36. Re: [WebDNA] Search Question (Tony Miller 2009)
  37. Re: [WebDNA] Search Question ( 2009)
  38. Re: [WebDNA] Search Question (Tony Miller 2009)
  39. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  40. Re: [WebDNA] Search Question ( 2009)
  41. [WebDNA] Search Question (Tony Miller 2009)
This is a multi-part message in MIME format. --------------080606090008050105000806 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello Stuart, Group search should do it:* http://www.webdna.us/page.dna?numero=69 group1field*=ORDERSTATUS&*group2field*=ORDERSTATUS&*group3field*=ORDERSTATUS negroup1data=5&negroup2data=6&negroup3data=12&ALLREQ=T Regards, Steve Stuart Tremain wrote: > I want to search a db and find records where ORDERSTATUS does not > equal 5 or 6 or 12 > > Can this be done in one search ? > > Or will I have to do a > > [HideIf |6|5|12|^|[ORDERSTATUS]|]===== hide record =====[/HideIf] > > > > Regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > --------------------------------------------------------- This message > is sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us -- --------------080606090008050105000806 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 
 Hello Stuart,Group search should do it:http://www.webdna.us/page.dna?numero=69group1field=ORDERSTATUS&group2field=ORDERSTATUS&group3field=ORDERSTATUSnegroup1data=5&negroup2data=6&negroup3data=12&ALLREQ=TRegards,Steve


Stuart Tremain wrote:
I want to search a db and find records where ORDERSTATUS does not equal 5 or 6 or 12

Can this be done in one search ?

Or will I have to do a 

[HideIf |6|5|12|^|[ORDERSTATUS]|]===== hide record =====[/HideIf]



Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us 

--
--------------080606090008050105000806-- Steve Raslevich

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:

taxTotal, grandTotal (1997) Repeating Fields (1997) WebCat2: Items xx to xx shown, etc. (1997) Security (1998) Sorting by date (1997) Faxing orders in place of email (1997) blank page from template (1997) Help formatting search results w/ table (1997) HomePage Caution (1997) WebCat2: multiple currency support (1997) really wierd browser truncating (1997) Field name-subcategory (1997) Weird problems with [SHOWIF]s (1997) Credit card types (1997) How do you hide [math]stuff[/math] (1997) Associative lookup style? + bit more (1997) credit card authorization question (1997) combining strings (1997) OT: Research Friendly Data Interface (2002) Error: Permision deny. (2005)