Re: Multiple catalog databases and showcart
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10688
interpreted = N
texte = >Here's the problem. I want to be able to add items to my cart from any >catalog database. How can I do a showcart for a cart than spans more than >one database?You can do that. Make sure you set db=xx for the proper database during the $add command. The only tough part is showing things like [title], [description], etc inside the [LineItems] loop. WebCatalog2 does some sophisticated stuff behind the scenes for you -- it automatically looks up those fields based on the sku and the database you name. But of course in a mixed cart, it doesn't know which database to look in.So, if you want to show something like [title] from different databases in the middle of a [LineItems] loop, you need to do a lookup in the proper database. During each $Add, set the TextA field to the name of the database you are adding from. Then in the middle of the [LineItems] loop, do a lookup in the database defined by TextA, looking for [sku]$Add?db=db1.db&sku=1234&TextA=db1.db (add sku 1234 from database db1) $Add?db=db2.db&sku=1234&TextA=db2.db (add sku 1234 from database db2...a completely different product, even though the sku could to be the same)[LineItems] Description: [lookup db=[TextA]&lookInField=sku&value=[sku]&returnField=description] (this replaces what would normally be simply [description]) [sku], [quantity], [price] [/LineItems]Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>Here's the problem. I want to be able to add items to my cart from any >catalog database. How can I do a showcart for a cart than spans more than >one database?You can do that. Make sure you set db=xx for the proper database during the $add command. The only tough part is showing things like [title], [description], etc inside the
[lineitems] loop. WebCatalog2 does some sophisticated stuff behind the scenes for you -- it automatically looks up those fields based on the sku and the database you name. But of course in a mixed cart, it doesn't know which database to look in.So, if you want to show something like [title] from different databases in the middle of a
[lineitems] loop, you need to do a lookup in the proper database. During each $Add, set the TextA field to the name of the database you are adding from. Then in the middle of the
[lineitems] loop, do a lookup in the database defined by TextA, looking for [sku]$Add?db=db1.db&sku=1234&TextA=db1.db (add sku 1234 from database db1) $Add?db=db2.db&sku=1234&TextA=db2.db (add sku 1234 from database db2...a completely different product, even though the sku could to be the same)
[lineitems] Description: [lookup db=[TextA]&lookInField=sku&value=[sku]&returnField=description] (this replaces what would normally be simply [description]) [sku], [quantity], [price] [/LineItems]Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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: what characters are replaced for tab and CR? (1998)
[WebDNA] Help with STMP Setup using Authentication with Google Apps in WebDNA (2016)
Hiding HTML and page breaks (1997)
Webcat causing crashes left and right! (1997)
[WebDNA] No more SQL in 7.1? (2012)
[WebDNA] Hmmm ... (2008)
pdf files? (2001)
Re:trouble (1997)
WebDNA Solutions ... sorry! (1997)
Cut off from the list and can't get an answer to the confused re:QTY price updating question (1998)
2nd WebCatalog2 Feature Request (1996)
Playin Tricks (2006)
Running _every_ page through WebCat ? (1997)
[shell} (2005)
WebCat2: Items xx to xx shown, etc. (1997)
Max Record length (1997)
Not carrying Zero (2000)
Requiring that certain fields be completed (1997)
# fields limited? (1997)
[WebDNA] Rack Mount Server(s) Available (2009)