Re: Why is my easy [AddLineItems] NOT working?? MORE
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34610
interpreted = N
texte = Thanks. I just tried that 1 hour before your mail and that is now working. On Thursday, 13 July 2000, Will Starck
wrote: >> 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 large > >Go 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/ >------------------------------------------------------------- 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:
Thanks. I just tried that 1 hour before your mail and that is now working. On Thursday, 13 July 2000, Will Starck wrote: >> 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 large > >Go 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/ >------------------------------------------------------------- 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/
Tim Robinson
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:
Shell on MacOSX (2004)
greater than or equal to (1997)
Looking up two prices in database? (1997)
MS Access data conversion (2001)
Text data with spaces in them... (1997)
Bug alert! (1997)
[WriteFile] problems (1997)
Cart doesn't interpret tag! (1997)
Closing Databases (1998)
[Shownext] [whynot] (2000)
WebCatalog for guestbook ? (1997)
changing prices in cart (1997)
AppleScript question (1997)
[OT] friday pics :-) (2005)
carrying values forward (1998)
[isfile] ? (1997)
Generating Report Totals (1997)
Trying to loop for letters (1999)
Limiting user access to .tmpl files (1997)
b12 cannot limit records returned and more. (1997)