Re: Stumped
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22864
interpreted = N
texte = 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?
Associated Messages, from the most recent to the oldest:
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?
Bob Minor
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:
Appending current [date] to a database (1997)
Forbidden CGI Error (1997)
re: Large databases in WebCat (1997)
Solution help needed (1998)
Almost a there but..bye bye NetCloak (1997)
problems with 2 tags (1997)
Help! WebCat2 bug (1997)
[defined]ish (1997)
Enhancement Request for WebCatalog-NT (1996)
[WebDNA] Variable truncating when using javascript openwindow (2011)
[TEXT SECURE=T] (2000)
Applescript error (1998)
orderfile stuff (1998)
From database to email (1999)
Multiple Pulldowns (1997)
Banners (1997)
webcat in the subject line - SMSI (2002)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
WebCommerce: Folder organization ? (1997)
# of real domains on 1 web server (1997)