Re: LineItem variable set
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68894
interpreted = N
texte = Why don't you just make a new database "lineitemdescriptions.db" with the fields "cart-id", "sku" and "description". Write the field values to this database whenever a new product is added to the cart, then you can lookup or search for the value when ever you like. Thierry Jim Ziegler schrieb: > Perhaps this is what you're looking for: > > [addlineitem > cart=[cart]&sku=[SKU]&db=DATABASEPATH]quantity=[quantity]&textA=[url][lookup > db= > DATABASEPATH&lookinfield=sku&value=[sku]&returnfield=description][/url][/addlineitem] > > > > --James P. Ziegler > Director of Web Services > Plank Road Publishing > www.MusicK8.com (Web Site for Music Teachers) > www.MusicK8Kids.com (Web Site for Students) > www.ResourcefulClassroom.com (Web Site for Classroom Teachers) > www.SchoolMusicMatters.com (Music Advocacy Web Site) > > > > On Apr 26, 2007, at 2:52 PM, Ki Song wrote: > >> Marc, I tried the code below, but it is still not working. >> >>> >>> [lineitems] >>> [text]description=[LOOKUP >>> db=databasePath&value=[sku]&lookInField=sku&returnField=description¬Found=] >>> >>> [/text] >>> >>> [showif [description]~PROMO] >>> [text show=t]validitem=t[/text] >>> [/showif] >>> >>> [/lineitems] >> >> The issue is this: WebDNA shopping carts do not normally store >> description >> fields. Therefore, it is impossible for me to search by the description >> field when inside of a shopping cart. >> Looking at the Programmer's Guide, it looks like the TextA field is >> something that can be used to store descriptions. I'm not sure exactly >> how >> this is accomplished. >> >> Anyone have sample code that will allow me to insert description >> fields into >> the shopping cart's TextA field? >> >> >> >> ------------------------------------------------------------- >> 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://webdna.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://webdna.smithmicro.com/ > -- --------------------------- mac&web gmbh thierry almy 8200 schaffhausen switzerland phone +41 (0)52 620 30 60 web www.mac-web.ch --------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Why don't you just make a new database "lineitemdescriptions.db" with the fields "cart-id", "sku" and "description". Write the field values to this database whenever a new product is added to the cart, then you can lookup or search for the value when ever you like. Thierry Jim Ziegler schrieb: > Perhaps this is what you're looking for: > > [addlineitem > cart=[cart]&sku=[SKU]&db=DATABASEPATH]quantity=[quantity]&textA=[url][lookup > db= > DATABASEPATH&lookinfield=sku&value=[sku]&returnfield=description][/url][/addlineitem] > > > > --James P. Ziegler > Director of Web Services > Plank Road Publishing > www.MusicK8.com (Web Site for Music Teachers) > www.MusicK8Kids.com (Web Site for Students) > www.ResourcefulClassroom.com (Web Site for Classroom Teachers) > www.SchoolMusicMatters.com (Music Advocacy Web Site) > > > > On Apr 26, 2007, at 2:52 PM, Ki Song wrote: > >> Marc, I tried the code below, but it is still not working. >> >>> >>> [lineitems] >>> [text]description=[LOOKUP >>> db=databasePath&value=[sku]&lookInField=sku&returnField=description¬Found=] >>> >>> [/text] >>> >>> [showif [description]~PROMO] >>> [text show=t]validitem=t[/text] >>> [/showif] >>> >>> [/lineitems] >> >> The issue is this: WebDNA shopping carts do not normally store >> description >> fields. Therefore, it is impossible for me to search by the description >> field when inside of a shopping cart. >> Looking at the Programmer's Guide, it looks like the TextA field is >> something that can be used to store descriptions. I'm not sure exactly >> how >> this is accomplished. >> >> Anyone have sample code that will allow me to insert description >> fields into >> the shopping cart's TextA field? >> >> >> >> ------------------------------------------------------------- >> 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://webdna.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://webdna.smithmicro.com/ > -- --------------------------- mac&web gmbh thierry almy 8200 schaffhausen switzerland phone +41 (0)52 620 30 60 web www.mac-web.ch --------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/
thierry
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:
Beta less tested (was $flushcache causes crash) (2000)
Date search - yes or no (1997)
drop down selection list for a search (1998)
capitalize each word? (2002)
Mondo amounts of Mail [long] (1999)
Examples Link? (2000)
Search in 2 or more catalogs (1997)
Re:Searching for ALL / empty form field (1997)
WebCat B13 Mac CGI -- Frames question (1997)
2.0 Beta (1997)
Security Issue (1997)
PCS Frames (1997)
Server crash (1997)
[WebDNA] Converting | to TAB (2010)
founditem align (1998)
Some Questions (1997)
[OT] Appropriate Signature??? (2003)
Running 2 two WebCatalog.acgi's (1996)
File not found error message (1998)
webcat- multiple selection in input field (1997)