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:

    
  1. Re: Stumped by [thisUrl] ( devaulw@onebox.com 2006)
  2. Re: Stumped by [thisUrl] ( Jesse Proudman 2006)
  3. Re: Stumped by [thisUrl] ( "Dan Strong" 2006)
  4. Re: Stumped by [thisUrl] ( Stuart Tremain 2006)
  5. Re: Stumped by [thisUrl] ( Stuart Tremain 2006)
  6. Re: Stumped by [thisUrl] ( Jesse Proudman 2006)
  7. Stumped by [thisUrl] ( "Dan Strong" 2006)
  8. Re: Sorting... stumped. ( "Dan Strong" 2006)
  9. Re: Sorting... stumped. ( Frank Nordberg 2006)
  10. Re: Sorting... stumped. ( "Dan Strong" 2006)
  11. Re: Sorting... stumped. ( Alex McCombie 2006)
  12. Re: Sorting... stumped. ( "Dan Strong" 2006)
  13. Re: Sorting... stumped. ( Alex McCombie 2006)
  14. Re: Sorting... stumped. ( "Dan Strong" 2006)
  15. Re: Sorting... stumped. ( "Dan Strong" 2006)
  16. Re: Sorting... stumped. ( "Dan Strong" 2006)
  17. Sorting... stumped. ( "Dan Strong" 2006)
  18. Re: stumped (Ken MacMurchy 2001)
  19. Re: stumped (Ken MacMurchy 2001)
  20. Re: stumped (Ken MacMurchy 2001)
  21. Re: stumped [OT] (Andrew Simpson 2001)
  22. Re: stumped [OT] (Donovan Brooke 2001)
  23. Re: stumped (Ken MacMurchy 2001)
  24. Re: stumped [OT] (Andrew Simpson 2001)
  25. Re: stumped [OT] (Donovan Brooke 2001)
  26. Re: stumped (Ken MacMurchy 2001)
  27. Re: stumped (Rob Marquardt 2001)
  28. Re: stumped (Rob Marquardt 2001)
  29. Re: stumped (John Peacock 2001)
  30. Re: stumped (Anup Setty 2001)
  31. Re: stumped (Anup Setty 2001)
  32. Re: stumped (Anup Setty 2001)
  33. Re: stumped (Jeff Grady 2001)
  34. Re: stumped (Ken MacMurchy 2001)
  35. Re: stumped (Sally Reidy 2001)
  36. stumped (Ken MacMurchy 2001)
  37. Re: stumped (Joseph Sullivan 2001)
  38. Re: Showif = stumped? (Jeff Logan 2001)
  39. Re: Showif = stumped? (William DeVaul, Connected Collector, Inc. 2001)
  40. Re: Showif = stumped? (Jeff Logan 2001)
  41. Re: Showif = stumped? (Brian Boegershausen 2001)
  42. Re: Showif = stumped? (Michael Winston 2001)
  43. Re: Showif = stumped? (Anup Setty 2001)
  44. Showif = stumped? (Jeff Logan 2001)
  45. Re: real beginner stumped (Scott Anderson 2000)
  46. Re: real beginner stumped (chris h ssd 2000)
  47. Re: real beginner stumped (Anup Setty 2000)
  48. Re: real beginner stumped (Matt 2000)
  49. Re: real beginner stumped (Kim Ingram 2000)
  50. Re: real beginner stumped (chris h ssd 2000)
  51. real beginner stumped (chris h ssd 2000)
  52. Re: Stumped on ShipCosts.db Problem (Bob McPeak 2000)
  53. Re: Stumped on ShipCosts.db Problem (John Butler 2000)
  54. Re: SuperFlush Re: stumped on simple sort (Rob Marquardt 1999)
  55. SuperFlush Re: stumped on simple sort (Ricky Patten 1999)
  56. Re: stumped on simple sort (Kenneth Grome 1999)
  57. Re: stumped on simple sort (Nitai 1999)
  58. Re: stumped on simple sort (david@textileweb.net (TextileWeb - David) 1999)
  59. Re: stumped on simple sort (Will Starck 1999)
  60. stumped on simple sort (John Butler 1999)
  61. Re: Stumped (Phil Marshall 1999)
  62. Re: Stumped (PCS Technical Support 1999)
  63. Re: Stumped (Kenneth Grome 1999)
  64. Re: Stumped (Alex McCombie 1999)
  65. Re: Stumped (Alex McCombie 1999)
  66. Re: Stumped (Bob Minor 1999)
  67. Stumped (Alex McCombie 1999)
  68. Re: Stumped (Dave MacLeay 1999)
  69. Ok, I'm stumped (M.I.S. Webmaster 1998)
  70. Re: Still Stumped on ShowNext...HELP! (Marty Schmid 1997)
  71. Re: Still Stumped on ShowNext...HELP! (Marty Schmid 1997)
  72. Re: Still Stumped on ShowNext...HELP! (Kenneth Grome 1997)
  73. Re: Still Stumped on ShowNext...HELP! (Olin 1997)
  74. Re: Still Stumped on ShowNext...HELP! (Grant Hulbert 1997)
  75. Still Stumped on ShowNext...HELP! (Marty Schmid 1997)
  76. Stumped on ShowNext -using variables (Marty Schmid 1997)
  77. Re: Generating unique SKU from [cart] - Still Stumped... (Christer Olsson 1997)
  78. Generating unique SKU from [cart] - Still Stumped... (Marty Schmid 1997)
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:

Resume Catalog ? (1997) Date Help (2004) Formulas.db + Users.db (1997) RE: [WebDNA] Send Mail and Outlook Express (2008) Attention SM: Trigger Bug? (2000) Physical Proximity searches (2000) Single Link browsing (1997) newbie Q: [cart] documentation (1999) Is there an alternative to emailer? (1999) Email...Thanks (1997) WebDNA Grep assistance [lowercase] (2003) question: webmerchant connection (1997) Ampersand Character (&) (1997) PSC recommends what date format yr 2000??? (1997) RE: Pop-Up Redirects (1998) Re:Running 2 two WebCatalog.acgi's (1996) TCPConnect to query for Domain expiration (2000) Why is deleting so slow? (2002) carriage returns in data (1997) Date question (2003)