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 >>> 422 This 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 Consultant 808-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 >>> 422 This 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 Consultant 808-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:
One more time (1997)
Where's 3.0 Online Docs? (1999)
WCS Newbie question (1997)
Bug Fix for wbrk??? (1999)
searchable list archive (1997)
Re1000001: Setting up shop (1997)
OT: Controlling WebStar's HTTP headers (1999)
b12 cannot limit records returned and more. (1997)
Cart Number Propagation (1997)
two of the same named db's open at once (1998)
searchable list archive (1997)
WebDNA Solutions ... (1997)
WebCat2 as a chat server? (1997)
WebCat2: Items xx to xx shown, etc. (1997)
[WebDNA] Line ending issues (2009)
[WebDNA] 64-bit CentOS 6.3 (2013)
[defined]ish (1997)
[WebDNA] test post (2011)
Variables for chat (1997)
Emailer setup (1997)