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:

Improper naming convections? (2004) Problem displaying search result (1997) [WebDNA] bug with max and startat (2010) Upload images to non DNA server (2004) [WebDNA] Lookup serial number of purchase? (2011) Search Questions (2000) Extended [ConvertChars] (1997) Webcat2, WebCommerce, Mod 10 etc. (1997) # of real domains on 1 web server (1997) Feature request: user-defined cart headers (1999) Am I going senile? (Price recalc based on quantity) (1997) Performance: deafening silence (1999) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [WebDNA] OT survey .... (2012) WebDNA Challenge - Was: Why WebDNA is not popular (2002) MacOS X Server problems (2001) The beginning (1997) problem with dates, NT version (1997) PSC recommends what date format yr 2000??? (1997) The text on this page exceeds 1 MB in length error (2000)