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:
View order not right (1997)
Configuring E-mail (1997)
Help! WebCat2 bug (1997)
WebDNA Intranet Edition release (2002)
international time (1997)
Emailer problem (2000)
question: webmerchant connection (1997)
AppleScript question (1997)
Search in 2 or more catalogs (1997)
AppleScript question (1997)
japanese characters (1997)
PCS Frames (1997)
Protect (1997)
WebCatalog stalls (1998)
carriage returns in data (1997)
Show if not working in version 4 (2002)
all records returned. (1997)
Re:Emailer and encryption (1997)
[Sum] function? (1997)
Formating found categories (1997)