Re: [WebDNA] Search question
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108869
interpreted = N
texte = Use groupingGroup1Fields=3DT_Bioenergy+T_Investment&neGroup1datarq=3DTTCOn 20 Mar 2012, at 11:08, Steve Craig wrote:> 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
Associated Messages, from the most recent to the oldest:
Use groupingGroup1Fields=3DT_Bioenergy+T_Investment&neGroup1datarq=3DTTCOn 20 Mar 2012, at 11:08, Steve Craig wrote:> 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
Toby Cox
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:
WebCat2: Items xx to xx shown, etc. (1997)
TPC Connect (1999)
Non-repeating Random Numbers - CORRECTION (2002)
WebCat2: multiple currency support (1997)
lookups (2000)
RE: WebCat vs. ASP (1999)
Security Question (1997)
href name= link from dynamic URL possible? (1998)
Massaging SubTotals (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
[WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009)
Protecting webdelivery (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Emailer problem (2000)
For those of you not on the WebCatalog Beta... (1997)
For those of you not on the WebCatalog Beta... (1997)
Width & Height (1998)
search form problem.. (1997)
Order not created error (1997)
[OT], Sorta: WebCat-Talk List (2000)