Re: OR-searching
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27708
interpreted = N
texte = on 17.02.2000 19:08, Brian Boegershausen at brianboegs@collegefever.comwrote:> You need to group the fields together and then use a wo .. word or ..> search string to find them.on 17.02.2000 19:15, WebDNA Support at webdna-support2@talk.smithmicro.comwrote:> try [search db=group.db&woGROUP_IDdatarq=1&woGROUP_IDdatarq=2]wo does not work, imagine such db values:212206422If I do a wo search for numbers 2 OR 12, I get the other numbers either,because they contain 2. What I need is to find exactly the values I'mlooking for. And in fact there will be more than two.The manual states:eqFIELDdatarq for AND searcheseqFIELDdata for OR searches...but this seems to work only for different fields.Hard to believe, that a database cannot find more than one specific value inone field, is there really no way except [showif]'s in the [founditems]loop?Peter-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
on 17.02.2000 19:08, Brian Boegershausen at brianboegs@collegefever.comwrote:> You need to group the fields together and then use a wo .. word or ..> search string to find them.on 17.02.2000 19:15, WebDNA Support at webdna-support2@talk.smithmicro.comwrote:> try [search db=group.db&woGROUP_IDdatarq=1&woGROUP_IDdatarq=2]wo does not work, imagine such db values:212206422If I do a wo search for numbers 2 OR 12, I get the other numbers either,because they contain 2. What I need is to find exactly the values I'mlooking for. And in fact there will be more than two.The manual states:eqFIELDdatarq for AND searcheseqFIELDdata for OR searches...but this seems to work only for different fields.Hard to believe, that a database cannot find more than one specific value inone field, is there really no way except [showif]'s in the [founditems]loop?Peter-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Peter Ostry
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:
WebCat2 beta 11 - new prefs ... (1997)
problems with 2 tags shakur (1997)
Unique SKU Numbers (2000)
pc (1997)
[protect] on NT? (1997)
Credit Card Number Stripping Digit (1997)
This list needs a digest: rant, rave... (1997)
Creating main- and sub-category search (1997)
RE: Which [index]? (1997)
MS Access (1999)
[WebDNA] users.db (2009)
New commands in Final candidate (1997)
Removing [showif] makes a big difference in speed (1997)
AppleScript does not work properly ... (2000)
[OT] Site test... (2003)
More on the email templates (1997)
The IBC root beer has arrived! (1997)
log out (2001)
vs (1997)
Some Questions (1997)