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:
OT: Need (a tiny bit) of help setting up MySQL (2000)
Locking up with WebCatalog... (1997)
Creating main- and sub-category search (1997)
Date Question (2002)
auto enter dates (1998)
MySQL Wildcard Trouble (2006)
Multi-Row Tables from a search. (1997)
Math, Multiple Equasions and Show/Hide (1998)
PCS Frames (1997)
Maybe minor bug report (1997)
restarting service remotely on NT (1997)
Search design (1997)
osx or redhat and / or other (2005)
To Do list (2003)
SiteGuard Use Question (1997)
wild question (1998)
add to cart within a page? (1997)
Deleting Orders (1997)
do you have a webcatalog tool you want to sell? (1999)
Search results templates (1996)