Re: Lookups
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30551
interpreted = N
texte = In general page design, I approach [Search] as the rule and [Lookup] as the exception. If I need to retrieve more than 1 or 2 fields from a secondary database, I try and rewrite the page to use two nested [Search] contexts.We had a site built by a contractor who was used to SQLServer and they used [Lookup] for every single field from every database. It made me completely nuts to see all that duplicated code so I spent about a half a day rewriting the code. The only troublesome page was one which could be called in an implied search context from two different databases (Authors and Books). I am still not happy with that one; YMMV.Hope this helpsJohn Peacock ____________________Reply Separator____________________ Subject: Lookups Author:
(WebCatalog Talk) Date: 4/15/2000 12:56 PMWhat is the maximum lookups you experts would put in a page before it would be better to do a search?I have a product detail page that brings back information about the rep that has consigned the item, I have first name, last name, address1, address2, city, state, zip, tel, fax. Is it better(faster) to do a lookup for each or is it better(faster) to do one nested search? This may be more opinion than anything, but in the pursuit of ever more efficient code I would like to get some feedback.Paul Fowler ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
In general page design, I approach [search] as the rule and [lookup] as the exception. If I need to retrieve more than 1 or 2 fields from a secondary database, I try and rewrite the page to use two nested [search] contexts.We had a site built by a contractor who was used to SQLServer and they used [lookup] for every single field from every database. It made me completely nuts to see all that duplicated code so I spent about a half a day rewriting the code. The only troublesome page was one which could be called in an implied search context from two different databases (Authors and Books). I am still not happy with that one; YMMV.Hope this helpsJohn Peacock ____________________Reply Separator____________________ Subject: Lookups Author: (WebCatalog Talk) Date: 4/15/2000 12:56 PMWhat is the maximum lookups you experts would put in a page before it would be better to do a search?I have a product detail page that brings back information about the rep that has consigned the item, I have first name, last name, address1, address2, city, state, zip, tel, fax. Is it better(faster) to do a lookup for each or is it better(faster) to do one nested search? This may be more opinion than anything, but in the pursuit of ever more efficient code I would like to get some feedback.Paul Fowler ------------------------------------------------------------- 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
jpeacock@univpress.com
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:
WebCat2 - Getting to the browser's username/password data (1997)
Some Advise needed (1997)
Creating folders and deleting files (1997)
[numFound] inside [showIf]? (2000)
AppleScript error (2003)
text size limitation (1997)
WC 2.0 frames feature (1997)
WebCat2 - [format thousands] (1997)
Multiple Pulldowns (1997)
[LINEITEMS] (2000)
Auto SKU's (2000)
FAX orders (1996)
[moveFile] Question (1999)
RE: MacFinder -- a new WebDNA web site (1998)
WebCat2 - [format thousands] (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
webcat NT with [dos] command (1997)
Deleting with contexts (2001)
[WebDNA] [BULK] db-temp files (2011)
Changes to [ReturnRaw] in 3.0 (1998)