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:

NT b19 sends extra MIME headers (1997) WebCatalog for Postcards ? (1997) Unexceling (was I need a smart quote...) (1999) [WebDNA] Where is Speed Test? (2009) math on date? (1997) PCS Frames (1997) [SEARCH] Context for SKU prices not working... (1998) Problem (1997) Server Freeze (1998) .htm file tags not showing up (2000) More questions about serial number dishing (1997) Here we go again... (2006) One Hour Email (2002) Math inside [showif] (1998) Include vs. lookup-opps (1998) show if date < expiry date (small corrections) (2002) [WebDNA] Numerous signal SIGSEGV then crashing - THANKS for the help (2016) BIG PROBLEMS with Checkboxes!!! (1998) [SHOWIF]s and empty arguments (1997) RE: Formulas.db + Users.db (1997)