Re: [Lookup] improvment [feature request]

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58707
interpreted = N
texte = You could implement this yourself as a [function]... [function name=mylookup] [return][lookup db=[tb]&value=[url][vl][/url]&lookinfield=[lif]&returnfield=[rf][showif [url][params_string][/url]^[url]&nf=[/url]]¬found=[url][nf][/url][/ showif]][/return] [/function] [mylookup db=brands.db&VL=[mylookup db=products.db&VL=[param6]&LIF=PRODUCT_ID&RF=BRAND]&LIF=ID&RF=urlValue] (not tested, but should be close) - brian On Jun 29, 2004, at 3:02 PM, Donovan Brooke wrote: > Hello, > I just wanted to ask this once more as right now I'm dealling with > a lot of nested lookups... > > This: > [lookup db=brands.db&value=[lookup > db=products.db&value=[param6]&lookinfield=PRODUCT_ID&returnfield=BRAND] > &lookinfield=ID&returnfield=urlValue] > > Would be more manageable in a syntax such as: > > [lookup db=brands.db&VL=[lookup > db=products.db&VL=[param6]&LIF=PRODUCT_ID&RF=BRAND]&LIF=ID&RF=urlValue] > > > I sure get tired of the long syntax... It would be nice to > have the abreviated version as an option. > > Anyone second the motion? > > Donovan ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [Lookup] improvment [feature request] ( Donovan Brooke 2004)
  2. Re: [Lookup] improvment [feature request] ( Brian Fries 2004)
  3. [Lookup] improvment [feature request] ( Donovan Brooke 2004)
You could implement this yourself as a [function]... [function name=mylookup] [return][lookup db=[tb]&value=[url][vl][/url]&lookinfield=[lif]&returnfield=[rf][showif [url][params_string][/url]^[url]&nf=[/url]]¬found=[url][nf][/url][/ showif]][/return] [/function] [mylookup db=brands.db&VL=[mylookup db=products.db&VL=[param6]&LIF=PRODUCT_ID&RF=BRAND]&LIF=ID&RF=urlValue] (not tested, but should be close) - brian On Jun 29, 2004, at 3:02 PM, Donovan Brooke wrote: > Hello, > I just wanted to ask this once more as right now I'm dealling with > a lot of nested lookups... > > This: > [lookup db=brands.db&value=[lookup > db=products.db&value=[param6]&lookinfield=PRODUCT_ID&returnfield=BRAND] > &lookinfield=ID&returnfield=urlValue] > > Would be more manageable in a syntax such as: > > [lookup db=brands.db&VL=[lookup > db=products.db&VL=[param6]&LIF=PRODUCT_ID&RF=BRAND]&LIF=ID&RF=urlValue] > > > I sure get tired of the long syntax... It would be nice to > have the abreviated version as an option. > > Anyone second the motion? > > Donovan ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Brian Fries

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) Requiring that certain fields be completed (1997) Smith Micro - no competition (2000) Bug Report, maybe (1997) [WebDNA] Processor Maxing out (2010) Authenticate (1997) Three new problems ... (1997) Fed Ex Rate Charts (2003) OT: RAID Options (2004) Searching for all records (1998) About WebDNA (2006) Re:quit command on NT (1997) Grant, please help me ... (1997) WebCatalog Mac 2.1b3 (1997) Email Scavengers (2003) Mac 2.1b4 unknown error: BadSuffix (1997) [WebDNA] Should I run the installer on an existing 8.x system on Ubuntu 14.04? (2015) need to add a sku field to an existing db (2005) Multiple Pulldowns (1997) WCS Newbie question (1997)