Re: lookup command
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23861
interpreted = N
texte = thanks Dave, I'll try ConvertChars again, although I tried some variation of your suggestion and it didn't work. I don't need the FunBoard entry -- just put it there because it works whereas Fun Board simply doesn't.JanDave MacLeay wrote:> Add new entries to your database for the two word varients: > > from
to > FunBoard2 > Fun Board2 > SummerFish3 > Summer Fish3 > > etc. > > 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:
thanks Dave, I'll try ConvertChars again, although I tried some variation of your suggestion and it didn't work. I don't need the FunBoard entry -- just put it there because it works whereas Fun Board simply doesn't.JanDave MacLeay wrote:> Add new entries to your database for the two word varients: > > fromto > FunBoard2 > Fun Board2 > SummerFish3 > Summer Fish3 > > etc. > > 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 --+
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:
RE: Can a database get stomped by simultaneous access? (1997)
Autonumber Work-Around (2003)
mod_webcatalog2.so (2003)
IIS4/IIS3 and WebCatalog registry settings (1998)
Dummy Credit Card Number for debug? (1997)
WebCatalog for Postcards ? (1997)
GD Scumbucket Spammer (2004)
Storeless in Seattle... (1998)
[WebDNA] Parsing XML...again... (2010)
Setting up shop (1997)
[shell] command (2000)
[WebDNA] Emailer breaking format (2015)
Help! WebCat2 bug (1997)
[OT] Wanted - Mail Server - MacOS9.x (2001)
emailer w/F2 (1997)
FORMS!! (2001)
[FoundItems] solved - thanks (1997)
WebCat2 - Getting to the browser's username/password data (1997)
2 easy questions re: [showif] and [sendmail] (1997)
WebDNA :: Product Reviews (2006)