Re: [WebDNA] Search question
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108871
interpreted = N
texte = HiI 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=3D1as 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=3DSteve Craig - Asylum Interactive LtdTel +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=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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=3DOn 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:
HiI 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=3D1as 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=3DSteve Craig - Asylum Interactive LtdTel +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=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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=3DOn 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)