Re: [WebDNA] Search question

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108871
interpreted = N
texte = Hi I now have=20 = &Group1field=3DT_Bioenergy+T_Investment+T_Jobs+T_Low_Carbon_Transport+T_Of= fshore_Main+T_Offshore_Wind+T_Onshore_Wind+T_Renewable_Heat+T_Smart_Energy= +T_Solar_Energy+T_Wave_Tidal&neGroup1datarq=3DT&asEXHIBITORNAMEsort=3D1 as the search string only problem is I think it is returning any record = that doesn't have a T in any of the boxes. What I want is any record = that doesn't have a T in ALL the boxes. In other words a record that has = not been assigned to any of the sections. At the moment it is returning = everything as every record has at least one of these fields empty. Hope = that makes sense. Any thoughts much appreciated. Cheers =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 20 Mar 2012, at 11:12, Toby Cox wrote: > Use grouping >=20 > Group1Fields=3DT_Bioenergy+T_Investment&neGroup1datarq=3DT >=20 >=20 > TC >=20 >=20 > On 20 Mar 2012, at 11:08, Steve Craig wrote: >=20 >> Hi >>=20 >> Sorry if this is really straightforward, I'm sure it is I just can't = get my head round it, not enough coffee!! >>=20 >> The page on the site in question is = http://www.all-energy.com/ExhibitDemo.html >>=20 >> Basically it is a list of exhibitors at an exhibition. The site owner = has buttons that show you which section the exhibitors are applicable = to, this is done with a database supplied by the owner that, among = others, have the following fields in it ... >>=20 >> T_Bioenergy >> T_Investment >> T_JobsT_Low_Carbon_Transport >> T_Offshore_Main >> T_Offshore_Wind=09 >> T_Onshore_Wind >> T_Renewable_Heat >> T_Smart_Energy >> T_Solar_Energy >> T_Wave_Tidal >>=20 >> If there is a T in field, the record will show up in the relevant = section. Pretty straightforward stuff. Each of these fields could have = either T or F or nothing and it is all supplied by the customer and = regularly bulk uploaded so I have to work with what I have. >>=20 >> My problem is the last button, what I need to show is any record that = does not have a T in any of the fields, in other words it is = uncategorizxd. I just am having a slow brain day. >>=20 >> I'm guessing I have to search for = neT_Bioenergydatarq=3DT&neT_Investment datarq=3DT& so on, I just thought = there might be a more efficient way? >>=20 >> Cheers >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1330 860550 Fax +44 1330 860880 >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >> http://www.asylumweb.com >> Email: steve@asylumweb.com >> Skype: s.craig - iChat: steve.craig >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>=20 >>=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 > --------------------------------------------------------- > 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 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)
Hi I now have=20 = &Group1field=3DT_Bioenergy+T_Investment+T_Jobs+T_Low_Carbon_Transport+T_Of= fshore_Main+T_Offshore_Wind+T_Onshore_Wind+T_Renewable_Heat+T_Smart_Energy= +T_Solar_Energy+T_Wave_Tidal&neGroup1datarq=3DT&asEXHIBITORNAMEsort=3D1 as the search string only problem is I think it is returning any record = that doesn't have a T in any of the boxes. What I want is any record = that doesn't have a T in ALL the boxes. In other words a record that has = not been assigned to any of the sections. At the moment it is returning = everything as every record has at least one of these fields empty. Hope = that makes sense. Any thoughts much appreciated. Cheers =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 20 Mar 2012, at 11:12, Toby Cox wrote: > Use grouping >=20 > Group1Fields=3DT_Bioenergy+T_Investment&neGroup1datarq=3DT >=20 >=20 > TC >=20 >=20 > On 20 Mar 2012, at 11:08, Steve Craig wrote: >=20 >> Hi >>=20 >> Sorry if this is really straightforward, I'm sure it is I just can't = get my head round it, not enough coffee!! >>=20 >> The page on the site in question is = http://www.all-energy.com/ExhibitDemo.html >>=20 >> Basically it is a list of exhibitors at an exhibition. The site owner = has buttons that show you which section the exhibitors are applicable = to, this is done with a database supplied by the owner that, among = others, have the following fields in it ... >>=20 >> T_Bioenergy >> T_Investment >> T_JobsT_Low_Carbon_Transport >> T_Offshore_Main >> T_Offshore_Wind=09 >> T_Onshore_Wind >> T_Renewable_Heat >> T_Smart_Energy >> T_Solar_Energy >> T_Wave_Tidal >>=20 >> If there is a T in field, the record will show up in the relevant = section. Pretty straightforward stuff. Each of these fields could have = either T or F or nothing and it is all supplied by the customer and = regularly bulk uploaded so I have to work with what I have. >>=20 >> My problem is the last button, what I need to show is any record that = does not have a T in any of the fields, in other words it is = uncategorizxd. I just am having a slow brain day. >>=20 >> I'm guessing I have to search for = neT_Bioenergydatarq=3DT&neT_Investment datarq=3DT& so on, I just thought = there might be a more efficient way? >>=20 >> Cheers >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1330 860550 Fax +44 1330 860880 >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >> http://www.asylumweb.com >> Email: steve@asylumweb.com >> Skype: s.craig - iChat: steve.craig >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>=20 >>=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 > --------------------------------------------------------- > 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 Steve Craig

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:

WebDNA on Redhat (2008) TCP Connect (2000) formulas.db (1999) File Upload (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Template Encrypt Speed (1998) A little help on e-mail (HELP!!! :-) ) (1998) Bug or syntax error on my part? (1997) emailer settings and control questions (1997) WebSTAR plugin update (2004) .. more on sliding discounts... (1997) Don't know if this is a sily question... (2003) Help! WebCat2 bug (1997) E-mailer error codes (1997) Using [random] (1999) Error Lob.db records error message not name (1997) searching multiple databases (1997) [WebDNA] Multiplication Math Test (2008) Understanding texta (1997) Include vs. lookup? (1998)