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:
Re:Can this be done? (1997)
[CART] (1997)
Quickie question on the email templates (1997)
WebCatalog Technical Reference (1997)
all records returned. (1997)
Minor Bug(?) with [Capitalize] context (1999)
Macs and SQL (2000)
MOOOOOO (2000)
# fields limited? (1997)
For those of you not on the WebCatalog Beta... (1997)
Still More on EudoraPro Email (1998)
How do I pass [cart] when user clicks back (2000)
where did it find it? (2000)
BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999)
Shopping problems with 2.1b3 acgi (1997)
Emailer setup (1997)
docs for WebCatalog2 (1997)
Cobalt RaQ Installation (2003)
How to append text after the sign & (1997)
Updating checkboxes made easy !!! (1998)