Re: [WebDNA] Advanced search 'rq' problem

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110506
interpreted = N
texte = or [HIDEIF [URL][sEMAIL][/URL]=3D]........[/HIDEIF] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 15/07/2013, at 6:32 PM, Tom Duke wrote: > Ok, >=20 > I think my problem is more fundamental here. If build up a complex = 'or' style search using a query like this: >=20 >=20 > search = db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641= 5894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&s= COMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3D= wo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo >=20 > I get a correct search result, but then if I want to omit certain = criteria by adding '&nesEMAILdatarq=3D[blank]' >=20 > search = db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641= 5894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&s= COMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3D= wo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatar= q=3D[blank] >=20 > then the search result is the same as: >=20 > search db=3Dpeople.db&nesEMAILdatarq=3D[blank] >=20 > 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? >=20 > Thanks > - Tom (whose head is starting to melt) >=20 >=20 >=20 >=20 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us 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)
or [HIDEIF [url][sEMAIL][/URL]=3D]........[/HIDEIF] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 15/07/2013, at 6:32 PM, Tom Duke wrote: > Ok, >=20 > I think my problem is more fundamental here. If build up a complex = 'or' style search using a query like this: >=20 >=20 > search = db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641= 5894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&s= COMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3D= wo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo >=20 > I get a correct search result, but then if I want to omit certain = criteria by adding '&nesEMAILdatarq=3D[blank]' >=20 > search = db=3Dpeople.db&sSECTIONSdata=3D|136407924352028766|&sBOFFICERdata=3D|13641= 5894854176046|&sCOFFICERdata=3D|136415955554188875|,|136415947654187207|&s= COMMITTEEdata=3D|136416335154313234|,|136416342654314722|&sSECTIONScomp=3D= wo&sBOFFICERcomp=3Dwo&sCOFFICERcomp=3Dwo&sCOMMITTEEcomp=3Dwo&nesEMAILdatar= q=3D[blank] >=20 > then the search result is the same as: >=20 > search db=3Dpeople.db&nesEMAILdatarq=3D[blank] >=20 > 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? >=20 > Thanks > - Tom (whose head is starting to melt) >=20 >=20 >=20 >=20 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us WebDNA

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:

Note added to [sendmail] in Docs (2004) Re2: frames & carts (1997) A question on sub-categories (1997) How to Sort Summ data ? (1997) setting line item numbers (1998) My solution... (1996) [WebDNA] Windows FastCGI thisurl issues (2018) Running more than one WebCatalog serial# (1998) Extended [ConvertChars] (1997) Re[2]: Date Time Oddness (1999) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Separate SSL Server (1997) WebCatalog2 Feature Feedback (1996) Trouble with formula.db (1997) Repeating Fields (1997) carriage returns in data (1997) Fun with dates (1997) Newbie Tax Question (1997) Search with Special Chars (1997) WebMerchant issues. (2000)