Re: lookup command

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23860
interpreted = N
texte = Add new entries to your database for the two word varients:fromto FunBoard2 Fun Board2 SummerFish3 Summer Fish3etc.Or you could create a custom conversions.db that changes spaces to nothing and modify your lookups:[lookup db=database/style.db&value=[ConvertChars db=removespaces.db][Style][/ConvertChars]&lookinfield=From&returnField=to]Where removespaces.db is something like:fromto Hope this helps.-Dave At 9:53 AM 2/19/99, Jan Kinzler wrote: >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 7 > >The 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 o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ 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)
Add new entries to your database for the two word varients:fromto FunBoard2 Fun Board2 SummerFish3 Summer Fish3etc.Or you could create a custom conversions.db that changes spaces to nothing and modify your lookups:[lookup db=database/style.db&value=[ConvertChars db=removespaces.db][Style][/ConvertChars]&lookinfield=From&returnField=to]Where removespaces.db is something like:fromto Hope this helps.-Dave At 9:53 AM 2/19/99, Jan Kinzler wrote: >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 7 > >The 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 o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

WCf2 and nested tags (1997) Error Lob.db records error message not name (1997) Convert Chars Q (2000) [OT] Mom's gift (2006) WebCatalog-NT?'s (1996) math on date? (1997) Decimal point in search.... (2004) Generating unique SKU from [cart] - Still Stumped... (1997) shipcost (1997) Unexpected error (1997) SendMail question (2004) Help with update to 2.11 (1998) RE: Formulas.db + Users.db (1997) Saving Text Areas with Orders (1997) A quickie question (1997) possible, WebCat2.0 and checkboxes-restated (1997) multi-paragraph fields (1997) Emailer and encryption (1997) searchable list archive (1997) WebDNA Solutions ... sorry! (1997)