Re: And/or Search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20173
interpreted = N
texte = Try something like this:[Searchdb=mydb.db&eqVar1datarq=Value1&eqgroup1datarq=Value2&group1field=Var2+Var3+Var4]Basicly, you're grouping all of your ORed fields together (group1field=),and then requiring a match in that group (eqgroup1datarq=), which ANDs itwith your other parameter (eqVar1datarq)-DaveAt 10:03 AM 10/1/98, Matthias Precht wrote:>Hello.>>Perhaps this is already discussed, but I cant find any help on this Topic>(even not in the docs)>>I have to build a search context for data matching the following criteria:>>Var1=Value1 AND ( Var2=Value2 OR Var3=Value2 OR Var4=Value2 aso.)>>If I write eqVar1datarq=Value1, every Record is displayed regardless of>Var2, Var3 etc....>>Can anybody help me out? Or is this impossible?>>Thanks>>Matthias Prechto--------------- Dave MacLeay --+o----------- Digital Frontier --+o--------------- 802.253.8612 --+o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
Try something like this:[Searchdb=mydb.db&eqVar1datarq=Value1&eqgroup1datarq=Value2&group1field=Var2+Var3+Var4]Basicly, you're grouping all of your ORed fields together (group1field=),and then requiring a match in that group (eqgroup1datarq=), which ANDs itwith your other parameter (eqVar1datarq)-DaveAt 10:03 AM 10/1/98, Matthias Precht wrote:>Hello.>>Perhaps this is already discussed, but I cant find any help on this Topic>(even not in the docs)>>I have to build a search context for data matching the following criteria:>>Var1=Value1 AND ( Var2=Value2 OR Var3=Value2 OR Var4=Value2 aso.)>>If I write eqVar1datarq=Value1, every Record is displayed regardless of>Var2, Var3 etc....>>Can anybody help me out? Or is this impossible?>>Thanks>>Matthias Prechto--------------- Dave MacLeay --+o----------- Digital Frontier --+o--------------- 802.253.8612 --+o--- dave@digitalfrontier.com --+
Dave MacLeay
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:
More questions about serial number dishing (1997)
Me know logical no need (2002)
Hairy Shipping Monster (2006)
PCS Frames (1997)
[WebDNA] WebDNA install on Redhat 4 64 bit? (2008)
carriage returns in data (1997)
quitting (1997)
Webcatalog 3.0.8 on PWS (2000)
list cookies and list http headers (1997)
Setting up shop (1997)
Help name our technology! (1997)
[WriteFile] problems (1997)
Formating found categories (1997)
[item] appears after 'remove last item' ... (1997)
Upgrading old WebCat Database Files (1997)
WebCat2 - storing unformatted date data? (1997)
Web requests in que... (2007)
Country & Ship-to address & other fields ? (1997)
How is it done? (1998)
Extended [ConvertChars] (1997)