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.db I 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:

    
  1. 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.db I 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)