Search question with a lookup (3 dbs)
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57708
interpreted = N
texte = Hi all,I am trying to solve a problem with a search context.I have 3 databases...: reseller.db products.db price.dbI want to be able to display a list (pricecomparison list) based on these 3 databases. But the criteria must be that the reseller, the product and the price as been marked as ENABLED (Enabled = ok to display). All of the 3 databases has a row indicating if a field is ENABLED og DISABLED.The code below does exactly what I want but does not check the reseller.db.So basicly the easiest thing would be to include this line within the 2. search context but that is not a valid thing to put inside since its not from the searched database.....&[lookup db=/admin/prischeck/db/ reseller.db&value=[db_price_reseller]&lookinfield=sku&returnfield=db_res eller_status]=1&...Any help ???-- snip - the code being used --[search db=/admin/prischeck/db/ products.db&eqdb_product_statusdata=1&asdb_product_namesort=1&max=25&All Reqd=T][founditems][search db=/admin/prischeck/db/ price.db&eqdb_price_produktdata=[sku]&asdb_price_resellersort=1&max=25&A llReqd=T][founditems][db_date][lookup db=/admin/prischeck/db/ products.db&value=[db_price_produkt]&lookinfield=sku&returnfield=db_prod uct_name][lookup db=/admin/prischeck/db/ reseller.db&value=[db_price_reseller]&lookinfield=sku&returnfield=db_res eller_name][db_price][/founditems][/search][/founditems][/search]-------------------------------------------------------------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:
|
- Search question with a lookup (3 dbs) ( Palle Bo Nielsen 2004)
|
Hi all,I am trying to solve a problem with a search context.I have 3 databases...: reseller.db products.db price.dbI want to be able to display a list (pricecomparison list) based on these 3 databases. But the criteria must be that the reseller, the product and the price as been marked as ENABLED (Enabled = ok to display). All of the 3 databases has a row indicating if a field is ENABLED og DISABLED.The code below does exactly what I want but does not check the reseller.db.So basicly the easiest thing would be to include this line within the 2. search context but that is not a valid thing to put inside since its not from the searched database.....&[lookup db=/admin/prischeck/db/ reseller.db&value=[db_price_reseller]&lookinfield=sku&returnfield=db_res eller_status]=1&...Any help ???-- snip - the code being used --[search db=/admin/prischeck/db/ products.db&eqdb_product_statusdata=1&asdb_product_namesort=1&max=25&All Reqd=T][founditems][search db=/admin/prischeck/db/ price.db&eqdb_price_produktdata=[sku]&asdb_price_resellersort=1&max=25&A llReqd=T][founditems][db_date][lookup db=/admin/prischeck/db/ products.db&value=[db_price_produkt]&lookinfield=sku&returnfield=db_prod uct_name][lookup db=/admin/prischeck/db/ reseller.db&value=[db_price_reseller]&lookinfield=sku&returnfield=db_res eller_name][db_price][/founditems][/search][/founditems][/search]-------------------------------------------------------------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/
Palle Bo Nielsen
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:
FINAL: STILL not starting on bootup - FIX? (2002)
Fun with dates (1997)
Purchase Plugin Missing (1996)
embedding commands in form (1999)
ANother SHOWIF problem (1997)
Multiple catalog databases and showcart (1997)
Happy New Year (2008)
Assigning carts (1998)
[WebDNA] News: Apple leaves MacWorld (2008)
system crashes, event log (1997)
E-mailer error codes (1997)
& in Lookups (1997)
docs for WebCatalog2 (1997)
buy 2 items get this free (2003)
Sendmail truncation in Eudora Clients (1998)
WebCat2b15MacPlugin - showing [math] (1997)
[searchString] (1997)
[date format] w/in sendmail (1997)
[WebDNA] WebDNA 8.6 announced - New features (2018)
In Digest Dijon (2000)