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:
[WebDNA] two ideas for running a cluster of WebDNA servers (2019)
Data Type Search Problem (2004)
Safari browser and WebDNA set-cookies (2003)
Emailer tracking (1997)
Search on encrypted field (2000)
For those of you not on the WebCatalog Beta... (1997)
Getting total number of items ordered (1997)
Sorry, WebDNA Server Not Running! (2005)
input and accents (2000)
[WebDNA] CICADA (2009)
lookup and two records? (1997)
06/06/2000 bug warning ... (2000)
problems with 2 tags (1997)
Constructive criticism (2000)
WebCatalog security on NT (2000)
Emailer on NT! (1998)
Multiple catalog databases and showcart (1997)
[ShowNext] feature in 2.0 (1997)
Socks Proxy Error (1999)
Listserver problem (1997)