Re: Stumped
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22873
interpreted = N
texte = >>>> I have a two db system where one field in db1 has data such as:>>>> 1234 1254 1256 2154>>> 4 digit numbers separated by a space.>>>> I need to do a secondary lookup/search on db2 that finds the>>>> matching values based on each 'word' in the field above such as:>>>> SKU \t Value>>>> 1234 \t This is what I am \r>>>> 1254 \t This is what I am2 \r>>>> 2154 \t This is what I am3 \r>>>> etc.Hi Alex,You confused me for a while with those \t and \r representations of
and , but now that I've figured out what you're describing, I think I have a version 2.x solution for you:[math]start=1[/math][math]end=4[/math][search db1.db&neskudata=[blank]][founditems][loop start=1&end=[format 0.f][math][countchars][fieldName][/countchars]/4[/math][/format]][lookup db=db2.db&lookinfield=SKU&value=[getchars start=[math]start[/math]&[math]end[/math]][fieldName][/getchars]&returnfield=Value][math]start=start+5[/math][math]end=end+5[/math][/loop][/founditems][/search]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>>> I have a two db system where one field in db1 has data such as:>>>> 1234 1254 1256 2154>>> 4 digit numbers separated by a space.>>>> I need to do a secondary lookup/search on db2 that finds the>>>> matching values based on each 'word' in the field above such as:>>>> SKU \t Value>>>> 1234 \t This is what I am \r>>>> 1254 \t This is what I am2 \r>>>> 2154 \t This is what I am3 \r>>>> etc.Hi Alex,You confused me for a while with those \t and \r representations of and , but now that I've figured out what you're describing, I think I have a version 2.x solution for you:[math]start=1[/math][math]end=4[/math][search db1.db&neskudata=[blank]][founditems][loop start=1&end=[format 0.f][math][countchars][fieldName][/countchars]/4[/math][/format]][lookup db=db2.db&lookinfield=SKU&value=[getchars start=[math]start[/math]&[math]end[/math]][fieldName][/getchars]&returnfield=Value][math]start=start+5[/math][math]end=end+5[/math][/loop][/founditems][/search]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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:
WebCat2.0 [format thousands .0f] no go (1997)
Checkbox question (1997)
Nested tags count question (1997)
WebTen and WebCat (1997)
Temp DB (Was freeze) (2003)
Squares instead of spaces (2001)
ANSWER to: CC Merchant suggestions?? (1997)
AOL and referrers on target=_blank (2000)
Odd Cart Behavior (1997)
Bug Report, maybe (1997)
[ShowIf] and empty fields (1997)
[ModDate] & [ModTime] ? (1997)
Re:What file? (1997)
WebCatalog Features (1997)
Variable security (2000)
WYSIWYG HTML editor for use in browser (2001)
Templates for Customer Database? (1997)
Search in 2 or more catalogs (1997)
[WebDNA] WebDNA Newbie Questions (2008)
WebCat2 Append problem (B14Macacgi) (1997)