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:
tcp connect includes (1999)
WebCatalog 2.0 b 15 mac (1997)
Bulletin Board (1998)
Ooops-Serial Number for NT (1997)
TRAINING videos - Prove IT. (1998)
Where is Typhoon 3.x? (2000)
Before I Can Begin . . . (1998)
[WebDNA] WebDNA Driven Forum (2009)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[ShowNext] feature in 2.0 (1997)
cart info (1998)
multiple databases (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
Alternating colors (1997)
japanese characters (1997)
[format xs] freeze (1997)
Duplicates (1998)
cookies (2001)
[Announce] Newest Commerce Site based on WebCatalog (1997)