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:from
toFunBoard2Fun Board2SummerFish3Summer Fish3etc.Or you could create a custom conversions.db that changes spaces to nothingand modify your lookups:[lookup db=database/style.db&value=[ConvertCharsdb=removespaces.db][Style][/ConvertChars]&lookinfield=From&returnField=to]Where removespaces.db is something like:fromtoHope this helps.-DaveAt 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 Kinzlero--------------- Dave MacLeay --+o----------- Digital Frontier --+o--------------- 802.253.8612 --+o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
Add new entries to your database for the two word varients:fromtoFunBoard2Fun Board2SummerFish3Summer Fish3etc.Or you could create a custom conversions.db that changes spaces to nothingand modify your lookups:[lookup db=database/style.db&value=[ConvertCharsdb=removespaces.db][Style][/ConvertChars]&lookinfield=From&returnField=to]Where removespaces.db is something like:fromtoHope this helps.-DaveAt 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 Kinzlero--------------- 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)