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:

Convert words (2002) Associative lookup style? (1997) WC2b15 File Corruption (1997) [Sum] function? (1997) no global [username] or [password] displayed ... (1997) international time (1997) Check Boxes (2000) I can help! (1996) WebCatalog2 Feature Feedback (1996) [OT] "&" char in Flash animation (2006) 5.0 Preview Promotion Extension (2003) Using Plug-In while running 1.6.1 (1997) Help with (2003) How to Sort Summ data ? (1997) Help! WebCat2 bug (1997) Bug Report, maybe (1997) WebDNA module - Automated database archiving (1997) Webcat 3 Bug?!?! Netscape + Protect + Posted Form (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Applescript error (1998)