Re: Stumped
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22867
interpreted = N
texte = Eeek.. Should have mentioned that we are using Webcat 2.1 mac. Not 3.x ;-(Trying to come up with a 2.x solution from what we have below. Should have stayed in bed ;-) Will be plugging away at it in the meantime. thanks Alex> Thanks Bob, > I haven't tried it but it looks great. I knew that I could count on > getting some relief from someone out there. I get sick twice a year or so, > and each time there is some damn deadline ;-) > > Thanks again. > > alex > > >> Yup! >> >> [!]I prefer to use a comma instead of a space, cause I can see it.[/!] >> [search db1.db&geskudata=0] >> [founditems] >> [!]This would work for a found set in db1.db[/!] >> [math show=f]wordcount=[countWords >> delimiters=,][afieldindb1][/countwords][/math] >> [!]again with the comma[/!] >> [ListWords >> words=[afieldindb1]&delimiters=,][text]wordtest[index]=[word][/text][/ListWo >> rds] >> [!]Use the count to loop through the possilbe searches. [/!] >> [loop start=1&end=[wordcount]] >> [!]I am using the wordloop to store these values for later.[/!] >> [!]lookup the values from another db[/!] >> [lookup >> db=db2.db&lookinfield=SKU&value=[interpret][wordtest[index]][/interpret]&ret >> urnfield=value] >> [/loop] >> [/founditems] >> [/search] >> ---------- >>>From: Alex McCombie
>>>To: WebDNA-Talk@smithmicro.com >>>Subject: Stumped >>>Date: Fri, Jan 22, 1999, 9:23 AM >>> >> >>> Ok, I'll admit it.. I'm sick and my brain isn't operating at normal speed. >>> >>> here's my need. >>> >>> 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. >>> >>> Just can't get the gray matter working this morning. Anyone feel like >>> helping a fever induced webcat programmer? >> >> > > > -- > Alexander J. McCombie (800-724-8973) > http://OurClients.com Corporate > http://McCombie.FamilyMail.net Personal > ChuckSpirit (AOLIM) > > http://Chat.Embark.com/ > <--- Now here's a serious Chat Room! ---> > > > -- Alexander J. McCombie (800-724-8973) http://OurClients.com Corporate http://McCombie.FamilyMail.net Personal ChuckSpirit (AOLIM) http://Chat.Embark.com/ <--- Now here's a serious Chat Room! --->
Associated Messages, from the most recent to the oldest:
Eeek.. Should have mentioned that we are using Webcat 2.1 mac. Not 3.x ;-(Trying to come up with a 2.x solution from what we have below. Should have stayed in bed ;-) Will be plugging away at it in the meantime. thanks Alex> Thanks Bob, > I haven't tried it but it looks great. I knew that I could count on > getting some relief from someone out there. I get sick twice a year or so, > and each time there is some damn deadline ;-) > > Thanks again. > > alex > > >> Yup! >> >> [!]I prefer to use a comma instead of a space, cause I can see it.[/!] >> [search db1.db&geskudata=0] >> [founditems] >> [!]This would work for a found set in db1.db[/!] >> [math show=f]wordcount=[countWords >> delimiters=,][afieldindb1][/countwords][/math] >> [!]again with the comma[/!] >> [ListWords >> words=[afieldindb1]&delimiters=,][text]wordtest[index]=[word][/text][/ListWo >> rds] >> [!]Use the count to loop through the possilbe searches. [/!] >> [loop start=1&end=[wordcount]] >> [!]I am using the wordloop to store these values for later.[/!] >> [!]lookup the values from another db[/!] >> [lookup >> db=db2.db&lookinfield=SKU&value=[interpret][wordtest[index]][/interpret]&ret >> urnfield=value] >> [/loop] >> [/founditems] >> [/search] >> ---------- >>>From: Alex McCombie >>>To: WebDNA-Talk@smithmicro.com >>>Subject: Stumped >>>Date: Fri, Jan 22, 1999, 9:23 AM >>> >> >>> Ok, I'll admit it.. I'm sick and my brain isn't operating at normal speed. >>> >>> here's my need. >>> >>> 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. >>> >>> Just can't get the gray matter working this morning. Anyone feel like >>> helping a fever induced webcat programmer? >> >> > > > -- > Alexander J. McCombie (800-724-8973) > http://OurClients.com Corporate > http://McCombie.FamilyMail.net Personal > ChuckSpirit (AOLIM) > > http://Chat.Embark.com/ > <--- Now here's a serious Chat Room! ---> > > > -- Alexander J. McCombie (800-724-8973) http://OurClients.com Corporate http://McCombie.FamilyMail.net Personal ChuckSpirit (AOLIM) http://Chat.Embark.com/ <--- Now here's a serious Chat Room! --->
Alex McCombie
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:
Multiple Pulldowns (1997)
Sort of a Dilema! (1998)
Search Question (2000)
Re[2]: Charting records by state (2000)
WebDNA tags in WebMerchant email templates ... (1997)
Removing items from a cart is wonky... (1998)
A few questions. . . (1997)
emailer truncates last letter! (1997)
Modtime bug? (2002)
all records returned. (1997)
Document Contains no data, or showcart error. (1997)
Share Snippet? (1999)
Comments in db? (1997)
No answers by SM? (2000)
How to Sort Summ data ? (1997)
Date Formats (1997)
R.I.P. Netscape (2003)
Formatting time output (2000)
[cart] not being interpreted inside [founditems] (1997)
Close Databases Crash? (1998)