lookup command

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23857
interpreted = N
texte = I'm using the lookup command to form my SKU and it works great when the from and to fields are limited to one word. For example, the style.db looks something like this:from to FunBoard 2 SummerFish 3 HiPerformance 4 Fish 5 BigBoy 6 LongBoard 7The lookup command is as follows and works fine with the above database, and the other two databases are essentially the same:SKU=[lookup db=database/style.db&value=[Style]&lookinfield=From&returnField=to][lookup db=database/graphic.db&value=[Graphic]&lookinfield=From&returnField=to][lookup db=database/colors.db&value=[Color]&lookinfield=From&returnField=to]But I need it to work for items like Fun Board Summer Fish and so on. Any advice greatly appreciated. thanks, Jan Kinzler Associated Messages, from the most recent to the oldest:

    
  1. Re: lookup command (Jan Kinzler 1999)
  2. Re: lookup command (Dave MacLeay 1999)
  3. lookup command (Jan Kinzler 1999)
  4. Re: Lookup command (Kenneth Grome 1998)
  5. Lookup command (RH Prouty 1998)
  6. Re: Lookup command (Bob Minor 1998)
  7. Re: lookup command (Kenneth Grome 1997)
  8. shipping calculations, lookup command (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
I'm using the lookup command to form my SKU and it works great when the from and to fields are limited to one word. For example, the style.db looks something like this:from to FunBoard 2 SummerFish 3 HiPerformance 4 Fish 5 BigBoy 6 LongBoard 7The lookup command is as follows and works fine with the above database, and the other two databases are essentially the same:SKU=[lookup db=database/style.db&value=[Style]&lookinfield=From&returnField=to][lookup db=database/graphic.db&value=[Graphic]&lookinfield=From&returnField=to][lookup db=database/colors.db&value=[Color]&lookinfield=From&returnField=to]But I need it to work for items like Fun Board Summer Fish and so on. Any advice greatly appreciated. thanks, Jan Kinzler Jan Kinzler

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:

getchars broken? (1997) Site Downloaders (2002) I give up!! (1997) Setting up the server (1997) Generating unique SKU from [cart] - Still Stumped... (1997) OT: Development contracts (1999) Multiple radio buttons (1998) Erotic Sites (1997) Weird Math and SV (1997) ListFiles and .DS_Store (2004) Emailer (1999) Replace with Producteditor.tpl (2000) How To question on setting up downloads (1997) [include] (1998) Upgrade to 4.0 (2001) textA and Title? (1997) [listfiles] with max? (2000) Multiple fields on 1 input (1997) searchable list archive (1997) Multi-processor Mac info ... (1997)