Re: Stumped

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22873
interpreted = N
texte = >>>> 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. Hi Alex,You confused me for a while with those \t and \r representations of and , but now that I've figured out what you're describing, I think I have a version 2.x solution for you:[math]start=1[/math] [math]end=4[/math][search db1.db&neskudata=[blank]] [founditems][loop start=1&end=[format 0.f][math][countchars][fieldName][/countchars]/4[/math][/format]][lookup db=db2.db&lookinfield=SKU&value=[getchars start=[math]start[/math]&[math]end[/math]][fieldName][/getchars]&returnfield=Value][math]start=start+5[/math] [math]end=end+5[/math][/loop][/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>>>> 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. Hi Alex,You confused me for a while with those \t and \r representations of and , but now that I've figured out what you're describing, I think I have a version 2.x solution for you:[math]start=1[/math] [math]end=4[/math][search db1.db&neskudata=[blank]] [founditems][loop start=1&end=[format 0.f][math][countchars][fieldName][/countchars]/4[/math][/format]][lookup db=db2.db&lookinfield=SKU&value=[getchars start=[math]start[/math]&[math]end[/math]][fieldName][/getchars]&returnfield=Value][math]start=start+5[/math] [math]end=end+5[/math][/loop][/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Re:Can this be done? (1997) [CART] (1997) Quickie question on the email templates (1997) WebCatalog Technical Reference (1997) all records returned. (1997) Minor Bug(?) with [Capitalize] context (1999) Macs and SQL (2000) MOOOOOO (2000) # fields limited? (1997) For those of you not on the WebCatalog Beta... (1997) Still More on EudoraPro Email (1998) How do I pass [cart] when user clicks back (2000) where did it find it? (2000) BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999) Shopping problems with 2.1b3 acgi (1997) Emailer setup (1997) docs for WebCatalog2 (1997) Cobalt RaQ Installation (2003) How to append text after the sign & (1997) Updating checkboxes made easy !!! (1998)