Re: LineItem variable set

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68895
interpreted = N
texte = Ki, Did you change the databasePath to your products database path? Is the field name in that datbase actually "description"? Is the unique identifier in your products db named "sku"? Did you try the earlier suggestion in your showif? [showif [GetChars start=1&end=5][description][/GetChars]=PROMO] [text show=t]validitem=t[/text] [/showif] Jim Ziegler's suggestion using the addlineitem looks right on the money for adding that value to the texta field. Marc 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/ > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- ------------------------------------------------------------- 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:

    
  1. Re: LineItem variable set ( Marc Thompson 2007)
  2. Re: LineItem variable set ( thierry 2007)
  3. Re: LineItem variable set ( Jim Ziegler 2007)
  4. Re: LineItem variable set ( Ki Song 2007)
  5. Re: LineItem variable set ( Marc Thompson 2007)
  6. Re: LineItem variable set ( Donovan Brooke 2007)
  7. Re: LineItem variable set ( Ki Song 2007)
  8. Re: LineItem variable set ( Marc Thompson 2007)
  9. Re: LineItem variable set ( Ki Song 2007)
  10. Re: LineItem variable set ( Marc Thompson 2007)
  11. Re: LineItem variable set ( Gary Krockover 2007)
  12. LineItem variable set ( Ki Song 2007)
Ki, Did you change the databasePath to your products database path? Is the field name in that datbase actually "description"? Is the unique identifier in your products db named "sku"? Did you try the earlier suggestion in your showif? [showif [GetChars start=1&end=5][description][/GetChars]=PROMO] [text show=t]validitem=t[/text] [/showif] Jim Ziegler's suggestion using the addlineitem looks right on the money for adding that value to the texta field. Marc 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/ > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- ------------------------------------------------------------- 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/ Marc Thompson

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:

WebCat & cookies (1998) totals (1997) Help name our technology! (1997) Clickable maps and WebCatalog? (1996) Using & in subject line (2003) PROBLEM (1997) Protect vs Authenicate (1997) Multi-processor Mac info ... (1997) WebCatalog for Dummies part 2 (2000) [Webcat 2]Next (1997) WebCatalog NT (1996) RE: Formulas.db + Users.db (1997) Webcat no longer supported? (2006) Emailer Chokes on bad address (1997) WebDNA - MySQL - PHP (2003) Before I Can Begin . . . (1998) docs for WebCatalog2 (1997) [shownext] help (2002) [WriteFile] problems (1997) OT - asp snippet similar to [!][/!] (2003)