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:
listfiles to aliased path OSX.2 (2002)
WC2/Mac -- Forms not submitting correctly with Mac browsers (1997)
Hiding HTML and page breaks (1997)
What happens to an include when a template gets encrypted? (2005)
Custom Tags or Modular Code (2001)
math a various prices (1997)
Re[2]: when is failing to [URL]ize values in a comparison ri (1999)
WebCatalog 2.0 b 15 mac (1997)
Thanks ! (1997)
Euro WebDNA Conference (2004)
More help for discount pricing (1998)
Cart Number sequence (1997)
AJAX with WebDNA (2006)
How can I Add several Items into the cart at once? (1997)
[cart] clarification... (1997)
Append User DB? (2000)
Requiring that certain fields be completed (1997)
Mac: LModelDirector bug fix (1997)
Digital Postcards (1999)
New Command prefs ... (1997)