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] > > > > > >[orderfile cart=[cart]] >[lineitems] > > > > > >[/lineitems] >[/orderfile] >
SkuProduct TitlePrice
[sku][lookup db=test.db&value=[sku]&lookinfield=sku&returnfield=title]$[format .2f][price][/format]
> > > > >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:

    
  1. Re: Why is my easy [AddLineItems] NOT working?? MORE (Tim Robinson 2000)
  2. Re: Why is my easy [AddLineItems] NOT working?? MORE (Will Starck 2000)
  3. Re: Why is my easy [AddLineItems] NOT working?? MORE (Kenneth Grome 2000)
  4. Re: Why is my easy [AddLineItems] NOT working?? MORE (Tim Robinson 2000)
  5. Re: Why is my easy [AddLineItems] NOT working?? MORE (WebDNA Support 2000)
  6. Re: Why is my easy [AddLineItems] NOT working?? MORE (Tim Robinson 2000)
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] > > > > > >[orderfile cart=[cart]] >[lineitems] > > > > > >[/lineitems] >[/orderfile] >
SkuProduct TitlePrice
[sku][lookup db=test.db&value=[sku]&lookinfield=sku&returnfield=title]$[format .2f][price][/format]
> > > > >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:

[WebDNA] shopping sites and the "old commerce tags" (2012) Greeting Card System (2000) [WebDNA] An unknown error occured // Deadlock avoided (2011) WebCatalog Prefs.ref file ? (1998) Forms Search Questions (1997) Error:Too many nested [xxx] contexts (1997) Fun With [TCP Connect] (1998) Sendmail: bounced e-mails (2001) Bug or syntax error on my part? (1997) [protect] on NT? (1997) email program problem (1998) Getting Values into Cart the easy way?* (1998) Strange intermittent WebDNA problems (2008) [WebDNA] Email sending issue (2017) Purchase command error problem (1997) Another issue with [Date format] (1998) upload pictures any solution (1999) Code ideas req: Matrix of users and options [code] (2003) Weird Math and SV (1997) & not allowed in db by definition? (1999)