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:

RE: Missing contexts on NT (1997) Creating a folder with WebCat? (2000) Bug or syntax error on my part? (1997) Repeating Fields (1997) Make sure I understand this??? (1997) Search/sort in URL Was: GuestBook example (1997) [WebDNA] List Files question (2009) HEADER AND FOOTER (1997) FEA REQ: One .hdr, multiple .db's (2003) Weird Cookie Problem - your answer (2007) Help! WebCat2 bug (1997) Sandbox CPU Usage Issue (2005) FYI: virus alert (1996) Text data with spaces in them... (1997) Lineitems [text*] (2004) psst (1997) SMSI (Scott) clues?? Bug fixes for next WebDNA release (2005) RAM variables (1997) Webstar 1.3.1 PPC (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)