Re: OR-searching
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27717
interpreted = N
texte = >>> try [search db=group.db&woGROUP_IDdatarq=1&woGROUP_IDdatarq=2]>>> in a database like this:>>>>>> GROUP_ID>>> 2>>> 12>>> 206>>> 422This search will fail because there are two parameters targeting the same database field. Please remember, it is NOT ALLOWED to search on a 'database' field with more than one parameter! If you need to search the same database field with more than one parameter, you MUST use the group field technique, like this:[search db=group.db&group1field=GROUP_ID&group2field=GROUP_ID&wogroup1datarq=1&wogroup2datarq=2]... because this is not actually searching on a 'database' field, it is actually searching on a 'group' field which you have created dynamically within the search context itself.The above search will retrieve all 4 records because either 1 or 2 appears in all of them. But if you want to retrieve only records which have *exactly* 1 or 2 in the GROUP_ID field (which in this case is only the first record) you must ALSO add the ww parameter to each search field, so the search context looks like this:[search db=group.db&group1field=GROUP_ID&group2field=GROUP_ID&wogroup1datarq=1&wogroup1datarq=2&group1word=ww&group2word=ww]Please note, I have added extra cr's to this code for clarity, so be sure to remove them if you're going to copy/paste these examples.================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:
>>> try [search db=group.db&woGROUP_IDdatarq=1&woGROUP_IDdatarq=2]>>> in a database like this:>>>>>> GROUP_ID>>> 2>>> 12>>> 206>>> 422This search will fail because there are two parameters targeting the same database field. Please remember, it is NOT ALLOWED to search on a 'database' field with more than one parameter! If you need to search the same database field with more than one parameter, you MUST use the group field technique, like this:[search db=group.db&group1field=GROUP_ID&group2field=GROUP_ID&wogroup1datarq=1&wogroup2datarq=2]... because this is not actually searching on a 'database' field, it is actually searching on a 'group' field which you have created dynamically within the search context itself.The above search will retrieve all 4 records because either 1 or 2 appears in all of them. But if you want to retrieve only records which have *exactly* 1 or 2 in the GROUP_ID field (which in this case is only the first record) you must ALSO add the ww parameter to each search field, so the search context looks like this:[search db=group.db&group1field=GROUP_ID&group2field=GROUP_ID&wogroup1datarq=1&wogroup1datarq=2&group1word=ww&group2word=ww]Please note, I have added extra cr's to this code for clarity, so be sure to remove them if you're going to copy/paste these examples.================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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
Kenneth Grome
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:
Commitdatabase tag (1998)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Error Messages Returned to User (1997)
removing programming logic white space (2003)
Error & Problem (1997)
06/06/2000 bug warning ... (2000)
PCS Frames (1997)
[/application] error? (1997)
Running _every_ page through WebCat ? (1997)
[sendmail] questions... (1997)
Using Plug-In while running 1.6.1 (1997)
WebCat2final1 crashes (1997)
Single Link browsing (1997)
Order not created error (never mind) (1997)
[LookUp] (1999)
Interface to Quickbooks (2005)
Server Problem (2004)
using showpage and showcart commands (1996)
Shopping cart now bad (1997)
tracking variables across a site... (2000)