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:

Email...Thanks (1997) Errata: WCS Newbie question (1997) [WebDNA] WebDNA 8.6 Ubuntu 16.04 (2018) Date search - yes or no (1997) [QuantityPrice] Not working in WebCatNT 2.0.1??? (1997) WC2f3 (1997) Bug Report, maybe (1997) OT : javascript form filling (2000) Finding max value for a field (1997) (long) Support (was wo search help) (1999) RE: PIXO support (1997) HELP WITH DATES (1997) I am sorry for always being such an ass (2004) [OT] MS Security Flaw (2000) Getting URL's entered manually (1997) Help DebugLevel Content-type: text/html (1998) bug in [SendMail] (1997) ShowNext (1997) webcat- multiple selection in input field (1997) [protect admin] (1997)