Re: [WebDNA] Advanced search 'rq' problem

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110504
interpreted = N
texte = --20cf303b3aef85c9f504e18f6753 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Ok, I think my problem is more fundamental here. If build up a complex 'or' style search using a query like this: search db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|136415= 894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&sCO= MMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3Dwo&= sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo I get a correct search result, but then if I want to omit certain criteria by adding '&nesEMAILdatarq=3D[blank]' search db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|136415= 894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&sCO= MMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3Dwo&= sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatarq=3D= [blank] then the search result is the same as: search db=3Dpeople.db&nesEMAILdatarq=3D[blank] maybe this is how WebDNA works? Is there any way to omit data from an 'or' style search? Or will I have to create a table and then carry out the omit search on the table? Thanks - Tom (whose head is starting to melt) --20cf303b3aef85c9f504e18f6753 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Ok,

I think my problem is more fundamen= tal here. =C2=A0 If build up a complex 'or' style search using a qu= ery like this:


search db=3Dpeople.d= b&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641589485= 4176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&= sCOMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScom= p=3Dwo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dw= o

I get a correct search result, but then if I want to om= it certain criteria by adding '&nesEMAILdatarq=3D[blank]'
=

search db=3Dpeople.db&sSECTIONSdata=3D|136407924352= 028766|&sBOFFICERdata=3D|136415894854176046|&sCOFFICERdata=3D|13641= 5955554188875|,|136415947654187207|&sCOMMITTEEdata=3D|13641633515431323= 4|,|136416342654314722|&sSECTIONScomp=3Dwo&sBOFFICERcomp=3Dwo&s= COFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatarq=3D[blank]

then the search result is the same as:
=
search db=3Dpeople.db&nesEMAILdatarq=3D[blank]
=

maybe this is how WebDNA works? =C2=A0 Is there any way= to omit data from an 'or' style search? =C2=A0 Or will I have to c= reate a table and then carry out the omit search on the table?

Thanks
- Tom (whose head is starting to melt)=






--20cf303b3aef85c9f504e18f6753-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Advanced search 'rq' problem (Alex McCombie 2013)
  2. Re: [WebDNA] Advanced search 'rq' problem (WebDNA 2013)
  3. Re: [WebDNA] Advanced search 'rq' problem (John Butler 2013)
  4. Re: [WebDNA] Advanced search 'rq' problem (Tom Duke 2013)
  5. Re: [WebDNA] Advanced search 'rq' problem (WebDNA 2013)
  6. Re: [WebDNA] Advanced search 'rq' problem (Tom Duke 2013)
  7. Re: [WebDNA] Advanced search 'rq' problem (John Butler 2013)
  8. [WebDNA] Advanced search 'rq' problem (Tom Duke 2013)
--20cf303b3aef85c9f504e18f6753 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Ok, I think my problem is more fundamental here. If build up a complex 'or' style search using a query like this: search db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|136415= 894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&sCO= MMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3Dwo&= sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo I get a correct search result, but then if I want to omit certain criteria by adding '&nesEMAILdatarq=3D[blank]' search db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|136415= 894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&sCO= MMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3Dwo&= sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatarq=3D= [blank] then the search result is the same as: search db=3Dpeople.db&nesEMAILdatarq=3D[blank] maybe this is how WebDNA works? Is there any way to omit data from an 'or' style search? Or will I have to create a table and then carry out the omit search on the table? Thanks - Tom (whose head is starting to melt) --20cf303b3aef85c9f504e18f6753 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Ok,

I think my problem is more fundamen= tal here. =C2=A0 If build up a complex 'or' style search using a qu= ery like this:


search db=3Dpeople.d= b&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641589485= 4176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&= sCOMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScom= p=3Dwo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dw= o

I get a correct search result, but then if I want to om= it certain criteria by adding '&nesEMAILdatarq=3D[blank]'
=

search db=3Dpeople.db&sSECTIONSdata=3D|136407924352= 028766|&sBOFFICERdata=3D|136415894854176046|&sCOFFICERdata=3D|13641= 5955554188875|,|136415947654187207|&sCOMMITTEEdata=3D|13641633515431323= 4|,|136416342654314722|&sSECTIONScomp=3Dwo&sBOFFICERcomp=3Dwo&s= COFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatarq=3D[blank]

then the search result is the same as:
=
search db=3Dpeople.db&nesEMAILdatarq=3D[blank]
=

maybe this is how WebDNA works? =C2=A0 Is there any way= to omit data from an 'or' style search? =C2=A0 Or will I have to c= reate a table and then carry out the omit search on the table?

Thanks
- Tom (whose head is starting to melt)=






--20cf303b3aef85c9f504e18f6753-- Tom Duke

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 Developer Resource Center (2002) OT: Limit on # of Pulldown entries (1997) Re:shipping code (1998) Searchable WebCat (etc.) Docs ? (1997) shipcost (1997) Pithy questions on webcommerce & siteedit (1997) WebMerchant 1.6 and SHTML (1997) Opinion: [input] should be called [output] ... (1997) [searchString] (1997) Test (2000) Resume Catalog ? (1997) Shopping Cart Problems (2000) Mac -Shareware Listserver (1998) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Popup Menu Options (1998) Weird Math and SV (1997) Bug? (1997) [include] and not found (2005) windows v4.5.1 (2003) carriage returns in data (1997)