Re: [WebDNA] SEARCH question

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107795
interpreted = N
texte = --Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Mmmm, I never thought of doing that :) On 13/12/2011, at 6:47 PM, Steve Raslevich wrote: > Hello Stuart, >=20 > Group search should do it: > http://www.webdna.us/page.dna?numero=3D69 >=20 > = group1field=3DORDERSTATUS&group2field=3DORDERSTATUS&group3field=3DORDERSTA= TUS >=20 > negroup1data=3D5&negroup2data=3D6&negroup3data=3D12&ALLREQ=3DT >=20 > Regards, > Steve >=20 >=20 > Stuart Tremain wrote: >>=20 >> I want to search a db and find records where ORDERSTATUS does not = equal 5 or 6 or 12 >>=20 >> Can this be done in one search ? >>=20 >> Or will I have to do a=20 >>=20 >> [HideIf |6|5|12|^|[ORDERSTATUS]|]=3D=3D=3D=3D=3D hide record = =3D=3D=3D=3D=3D[/HideIf] >>=20 >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> --------------------------------------------------------- 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 >=20 > --=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=iso-8859-1 Mmmm, I never thought of doing that :)


On 13/12/2011, at 6:47 PM, Steve Raslevich wrote:

 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 

--
--------------------------------------------------------- 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

--Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0-- 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)
--Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Mmmm, I never thought of doing that :) On 13/12/2011, at 6:47 PM, Steve Raslevich wrote: > Hello Stuart, >=20 > Group search should do it: > http://www.webdna.us/page.dna?numero=3D69 >=20 > = group1field=3DORDERSTATUS&group2field=3DORDERSTATUS&group3field=3DORDERSTA= TUS >=20 > negroup1data=3D5&negroup2data=3D6&negroup3data=3D12&ALLREQ=3DT >=20 > Regards, > Steve >=20 >=20 > Stuart Tremain wrote: >>=20 >> I want to search a db and find records where ORDERSTATUS does not = equal 5 or 6 or 12 >>=20 >> Can this be done in one search ? >>=20 >> Or will I have to do a=20 >>=20 >> [HideIf |6|5|12|^|[ORDERSTATUS]|]=3D=3D=3D=3D=3D hide record = =3D=3D=3D=3D=3D[/HideIf] >>=20 >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> --------------------------------------------------------- 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 >=20 > --=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=iso-8859-1 Mmmm, I never thought of doing that :)


On 13/12/2011, at 6:47 PM, Steve Raslevich wrote:

 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 

--
--------------------------------------------------------- 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

--Apple-Mail=_5E827945-9973-4694-9E0D-35BF5623E1E0-- Stuart Tremain

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:

Strange error (2000) converted seed value? (1998) Multiple email troubles (solved) (2001) Release of 2.01? (1997) DDE feature in webcat (1998) Deadlock (1999) Emailer Q (2002) RAM variables (1997) Help Wanted - Stowe, Vermont (1999) Post size Limit? (1998) Robert Minor duplicate mail (1997) [ShowNext] (1997) Searching multiple Databases (1997) WebCat2.0 [format thousands .0f] no go (1997) can WC render sites out? (1997) How far do [showif]s go? (1997) [WebDNA] 2 x servers, 1 x db (2018) [WebDNA] triggers.db "next execute" fails to update (2012) Emailer setup (1997) [WebDNA] Error 500 with SUMM=T (2017)