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 size fubar 95.50 app002 largeGo here to see it ---> http://shop.novaderm.com/Test/test.tpl-- Will Starck Product and Technical Support NovaDerm.com http://www.novaderm.com techs@novaderm.com Toll 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 size fubar 95.50 app002 largeGo here to see it ---> http://shop.novaderm.com/Test/test.tpl-- Will Starck Product and Technical Support NovaDerm.com http://www.novaderm.com techs@novaderm.com Toll 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:
orderfile and setlineitems (1998)
ups shipping based on weight (1999)
Webalizer 4.5.0 [sendmail] on RH Linux 7.3 with qmail (2003)
Rotating Banners ... (was LinkExchange) (1997)
Problem with [CART] number (1998)
[WebDNA] OT: length of an HTML form input's 'name' parameter? (2010)
Credit Card Number checking (1997)
Next (1997)
Emailer 1.0.2 Conflicts? (1998)
SV: Strange sort in search... (2000)
texta,b,c,d,e (urgent) (2003)
Where's Cart Created ? (1997)
Showif probably dumb question (1997)
Another question about credit cards (1997)
WebCatalog can't find database (1997)
SiteGuard Admin Feature ? (1997)
Another question (1997)
Cart date/time (2006)
Errata: WCS Newbie question (1997)
showif comparison begins w/ and contains (1997)