Re: Why is my easy [AddLineItems] NOT working?? MORE
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34609
interpreted = N
texte = > But I also want to show the Product name from> the database. Is this possible?Simple. Use [lookup]. Here's a stripped down example:[addlineitem db=test.db&cart=[cart]&sku=app002]quantity=1[/addlineitem]
Sku | Product Title | Price | [orderfile cart=[cart]][lineitems][sku] | [lookup db=test.db&value=[sku]&lookinfield=sku&returnfield=title] | $[format .2f][price][/format] |
[/lineitems][/orderfile]
Test.db looks like this:title price sku sizefubar 95.50 app002 largeGo here to see it ---> http://shop.novaderm.com/Test/test.tpl-- Will StarckProduct and Technical SupportNovaDerm.comhttp://www.novaderm.comtechs@novaderm.comToll free support line: 800-378-1740-- > From: Tim Robinson
> Reply-To: (WebCatalog Talk)> Date: 13 Jul 2000 11:21:30> To: (WebCatalog Talk)> Subject: Re: Why is my easy [AddLineItems] NOT working?? MORE> > But this is the basis of my problem. I'm not using a command=add, I'm using a> form on a results.tpl to add multiple items and quantities, and an> [AddLineItem] on the cart page.> > Can you use a 'textA' variable in an [AddLineItem] context? I tried it, but it> didn't work. I've got a textA variable in another database, but that occurs in> a [SetLineItem] context on the invoice page.> > Basically, how can I get the product names to appear in the cart? Thanks for> all your help.> > Regards,> Tim> > Tim Robinson> Art Director> imagine online> tim@imagine.au.com> http://www.imagine.au.com> > > On Thursday, 13 July 2000, WebDNA Support > wrote:>>> In Database 2, a hyperlink adds the product to the cart >> HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=lib.db&sku=[url][sku>>> ][/url]>Add to Cart.>>> Here though, the product name DOES display in the [LineItems]. No problem!>>> What's going on?>> >> In order to make it easier to code your [LineItems] loops to display>> product database fields, WebCatalog will automatically use the db and>> sku you provide to do a lookup on any product database fieldname>> which appears inside the [LineItems] loop. This works for>> command=Add/Remove/Clear/Purchase/ShowCart>> >> Technical Support **********************************>> Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)>> 16855 West Bernardo Drive, #380 | ------------------------->> San Diego, CA 92127 | Software & Site Development>> WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com>> Fax: (858) 675-0372>> **********************************>> >> ------------------------------------------------------------->> 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://search.smithmicro.com/>> > > > > -------------------------------------------------------------> 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://search.smithmicro.com/-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
> But I also want to show the Product name from> the database. Is this possible?Simple. Use [lookup]. Here's a stripped down example:[addlineitem db=test.db&cart=[cart]&sku=app002]quantity=1[/addlineitem]Sku | Product Title | Price | [orderfile cart=[cart]][lineitems][sku] | [lookup db=test.db&value=[sku]&lookinfield=sku&returnfield=title] | $[format .2f][price][/format] |
[/lineitems][/orderfile]
Test.db looks like this:title price sku sizefubar 95.50 app002 largeGo here to see it ---> http://shop.novaderm.com/Test/test.tpl-- Will StarckProduct and Technical SupportNovaDerm.comhttp://www.novaderm.comtechs@novaderm.comToll free support line: 800-378-1740-- > From: Tim Robinson > Reply-To: (WebCatalog Talk)> Date: 13 Jul 2000 11:21:30> To: (WebCatalog Talk)> Subject: Re: Why is my easy [AddLineItems] NOT working?? MORE> > But this is the basis of my problem. I'm not using a command=add, I'm using a> form on a results.tpl to add multiple items and quantities, and an> [addlineitem] on the cart page.> > Can you use a 'textA' variable in an [addlineitem] context? I tried it, but it> didn't work. I've got a textA variable in another database, but that occurs in> a [setlineitem] context on the invoice page.> > Basically, how can I get the product names to appear in the cart? Thanks for> all your help.> > Regards,> Tim> > Tim Robinson> Art Director> imagine online> tim@imagine.au.com> http://www.imagine.au.com> > > On Thursday, 13 July 2000, WebDNA Support > wrote:>>> In Database 2, a hyperlink adds the product to the cart >> HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=lib.db&sku=[url][sku>>> ][/url]>Add to Cart.>>> Here though, the product name DOES display in the [lineitems]. No problem!>>> What's going on?>> >> In order to make it easier to code your [lineitems] loops to display>> product database fields, WebCatalog will automatically use the db and>> sku you provide to do a lookup on any product database fieldname>> which appears inside the [lineitems] loop. This works for>> command=Add/Remove/Clear/Purchase/ShowCart>> >> Technical Support **********************************>> Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)>> 16855 West Bernardo Drive, #380 | ------------------------->> San Diego, CA 92127 | Software & Site Development>> WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com>> Fax: (858) 675-0372>> **********************************>> >> ------------------------------------------------------------->> 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://search.smithmicro.com/>> > > > > -------------------------------------------------------------> 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://search.smithmicro.com/-------------------------------------------------------------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://search.smithmicro.com/
Will Starck
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:
WebDNA within the shell (2004)
remotely add + sign (1997)
WebCatalog 4 Install Problems (2000)
[WebDNA] WebDNA future (2010)
Images do not upload completely ... (2003)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
How to get shownext to just shownext once (1997)
2.1b3 --> way slow (1997)
WebMerchant 1.6 and SHTML (1997)
[referrer] tag (1997)
Flash Stores (2003)
Nested search (1997)
ShowNext (1997)
Sorting problem (2002)
.tmp files (2000)
Orders w/in [sendmail] (1998)
[WebDNA] I can't log into WebDNA (2014)
Moment of Thanks (1997)
[purchase] question (2000)
Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= (2004)