Re: [WebDNA] Advanced search 'rq' problem
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110505
interpreted = N
texte = > 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? I think that is how Webdna works... or at least I don't know that there = is any unexpected behavior in your results. You ask a good question. =20 No inspirations come to mind as an answer.. if I was in a hurry I would = probably just do what you just said - dump the OR results into a table = and then filter that. BTW, you are right about needing to use a radio button instead of the = checkbox in my last email/example, or else add a conditional wrapper = that sticks in zero chars when the var is uninitialized. -Govinda
Associated Messages, from the most recent to the oldest:
> 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? I think that is how Webdna works... or at least I don't know that there = is any unexpected behavior in your results. You ask a good question. =20 No inspirations come to mind as an answer.. if I was in a hurry I would = probably just do what you just said - dump the OR results into a table = and then filter that. BTW, you are right about needing to use a radio button instead of the = checkbox in my last email/example, or else add a conditional wrapper = that sticks in zero chars when the var is uninitialized. -Govinda
John Butler
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:
Nesting format tags (1997)
Locking up with WebCatalog... (1997)
HomePage Caution (1997)
[username][password] not showing up! HELP! (1999)
Anyone with a solution for this? (2001)
Surprise x and y post args (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
Show of Hands (2002)
No luck with taxes (1997)
Almost a there but..bye bye NetCloak (1997)
Grep Question - MAY NEVER BE SOLVED (2003)
[WebDNA] How WebDNA email sending works... (2012)
method of payment (1997)
RE: Any limit to [include] (1997)
WebCat2b15MacPlugin - [protect] (1997)
Re:Formulas.db / Quantity Discount problem (1998)
[WebDNA] User Management System [Cookie] (2008)
All choices on IE different than Netscape (1997)
how to post without certain data appearing in the html source (2001)
Permissions Ignored - PLEASE HELP (2003)