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:

Deleting Orders (1997) Lookup Notfound (1998) Domain serial issue (2008) HELP WITH DATES (1997) [BULK] [WebDNA] [BULK] search tag just not working (2012) Why no EMailFolder? (2001) RAM variables (1997) HTML Editors (1997) Random sort is not random at all..... (2000) Calendar (1997) Another IfThenElse question.. (2003) success - serial numbers and webmerch (1997) I need Typhoon Pro Tonight! (1999) New Command prefs ... (1997) New Website with Redakto CMS (2003) can WC render sites out? (1997) Which Pref is faster? (1998) how many (hideif & showifs) is too many? (2001) Getting Total Quantity (1997) ThisURL on Unix (2000)