Re: [REPLACE] inside [FOUNDITEMS]

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19184
interpreted = N
texte = >Since all changes are RAM-based and _instantanious_, the behaivior that you >described is normal and expected.Dave's description is exactly correct. What's really going on inside a [LineItems] loop when you display a field like [INV] is that a [Lookup] is being done for you that finds the corresponding SKU for that lineitem and grabs that field's value from the database. If you change the database, you change the value. If we didn't do this magic for you, then you'd be stuck doing lookups yourself in WebDNA every time you wanted a field out of the database, and that could look ugly real quick.The correct way to do this in your case is to use the textA-E fields in the order file to store values from the database at the moment you add something to the cart. [TextA] will always look in the orderfile itself rather than dynamically look in the database. You can see the GeneralStore stores the [Title] field this way.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [REPLACE] inside [FOUNDITEMS] (Kenneth Grome 1998)
  2. Re: [REPLACE] inside [FOUNDITEMS] (Peter Ostry 1998)
  3. Re: [REPLACE] inside [FOUNDITEMS] (Michael Winston 1998)
  4. Re: [REPLACE] inside [FOUNDITEMS] (Kenneth Grome 1998)
  5. Re: [REPLACE] inside [FOUNDITEMS] (Bob Minor 1998)
  6. Re: [REPLACE] inside [FOUNDITEMS] (PCS Technical Support 1998)
  7. Re: [REPLACE] inside [FOUNDITEMS] (Michael Winston 1998)
  8. Re: [REPLACE] inside [FOUNDITEMS] (PCS Technical Support 1998)
  9. Re: [REPLACE] inside [FOUNDITEMS] (Dave MacLeay 1998)
  10. Re: [REPLACE] inside [FOUNDITEMS] (PCS Technical Support 1998)
  11. Re: [REPLACE] inside [FOUNDITEMS] (Kenneth Grome 1998)
  12. RE: [REPLACE] inside [FOUNDITEMS] (Olin 1998)
  13. [REPLACE] inside [FOUNDITEMS] (Michael Winston 1998)
  14. Re: [REPLACE] inside [FOUNDITEMS] (Dave MacLeay 1998)
  15. RE: [REPLACE] inside [FOUNDITEMS] (Olin 1998)
>Since all changes are RAM-based and _instantanious_, the behaivior that you >described is normal and expected.Dave's description is exactly correct. What's really going on inside a [lineitems] loop when you display a field like [INV] is that a [lookup] is being done for you that finds the corresponding SKU for that lineitem and grabs that field's value from the database. If you change the database, you change the value. If we didn't do this magic for you, then you'd be stuck doing lookups yourself in WebDNA every time you wanted a field out of the database, and that could look ugly real quick.The correct way to do this in your case is to use the textA-E fields in the order file to store values from the database at the moment you add something to the cart. [TextA] will always look in the orderfile itself rather than dynamically look in the database. You can see the GeneralStore stores the [Title] field this way.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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] Installed but can't configure (2016) PSC recommends what date format yr 2000??? (1997) Pgp&emailer (1997) method of payment (1997) v5 request (2002) Mac: [ListFiles] bug alert (1997) [url] (1997) WebCatalog 3.0.4 alias crash bug? (2000) REPOST: How do _you_ back up your db? (2000) WebCatalog for guestbook ? (1997) Searching multiple Databases (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Major Security Hole (1998) # fields limited? (1997) Generating Report Totals (1997) webcat2b12 CGI -- Date comparisons (1997) Country & Ship-to address & other fields ? (1997) using showpage and showcart commands (1996) Math Context (1998) Multiple prices (1997)