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:
virtual virtual hosted store.... (1998)
Logging purchases (1997)
Windows 2.1b2 Append Bug? (1997)
CloseDataBase vs CommitDataBase (2007)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
[WebDNA] How to valuate a domain name? (2010)
international time (1997)
Credit Card not accepted (1998)
OT : Virus (2000)
Mass deletion of records (2006)
PIXO (1997)
Clean Code: Rules for inserting keyboard returns? (1997)
WebCat2final1 crashes (1997)
WebCat2 beta 11 - new prefs ... (1997)
Emailer setup (1997)
Nested tags count question (1997)
[WebDNA] Date and Time as numbers (2009)
Weird Math and SV Bad News (1997)
RE: protect tag on NT (1997)
Help with a pull down menu (1999)