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=[countWordsdelimiters=,][afieldindb1][/countwords][/math][!]again with the comma[/!][ListWordswords=[afieldindb1]&delimiters=,][text]wordtest[index]=[word][/text][/ListWords][!]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[/!][lookupdb=db2.db&lookinfield=SKU&value=[interpret][wordtest[index]][/interpret]&returnfield=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=[countWordsdelimiters=,][afieldindb1][/countwords][/math][!]again with the comma[/!][ListWordswords=[afieldindb1]&delimiters=,][text]wordtest[index]=[word][/text][/ListWords][!]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[/!][lookupdb=db2.db&lookinfield=SKU&value=[interpret][wordtest[index]][/interpret]&returnfield=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:
international time (1997)
Fwd: Web DNA... (2007)
[OT] Conversion from QuickMail Pro (2002)
What does this error mean? (2000)
Somewhat OT: IE issues (2002)
Quit revisited (1997)
OT New use for WebCat (1998)
WebCatalog Technical Reference (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Problems with [Applescript] (1997)
"Advanced" Search Algorithm (2008)
WebCatalog Plug-in for Webstar. (1997)
country of origin from IPADDRESS??? (2001)
Related database (2000)
WC2.0 Memory Requirements (1997)
Signal Raised Error (Part II) (1997)
Replace Statement (1997)
How can I Add several Items into the cart at once? (1997)
WebCatalog Hosting (1996)
Harvesting invalid email addresses from bounced emails??? (2000)