Re: View order not right

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11964
interpreted = N
texte = >When I go to view an order that has just been placed everything is in >there except the Title of the good purchased all I see is [title]. I >believe this is why I keep getting mail errors that say handled with >error I get the mail 90% of the time. Where should I look?The View Order URL probably is missing the db=catalog.txt -- that's how an order file knows where to look up the SKU to determine field values like [title].If you look at the docs for the Order File Format, you'll see that the order file never actually stores the field values from your database. So WebCatalog has no idea what [title] or [YourCustomField] means in the context of an order. Al it knows about are things like [textA], [price], and such. Being the nice programmer that I am, I added a special ability so that if you specify a database while doing a $ShowCart, WebCatalog will do a lookup in that database using the SKU stored in the lineitem of that shopping cart item.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: View order not right (Grant Hulbert 1997)
  2. Re: View order not right (Grant Hulbert 1997)
  3. Re: View order not right (bob 1997)
  4. Re: View order not right (Kenneth Grome 1997)
  5. View order not right (bob 1997)
>When I go to view an order that has just been placed everything is in >there except the Title of the good purchased all I see is [title]. I >believe this is why I keep getting mail errors that say handled with >error I get the mail 90% of the time. Where should I look?The View Order URL probably is missing the db=catalog.txt -- that's how an order file knows where to look up the SKU to determine field values like [title].If you look at the docs for the order file Format, you'll see that the order file never actually stores the field values from your database. So WebCatalog has no idea what [title] or [YourCustomField] means in the context of an order. Al it knows about are things like [textA], [price], and such. Being the nice programmer that I am, I added a special ability so that if you specify a database while doing a $ShowCart, WebCatalog will do a lookup in that database using the SKU stored in the lineitem of that shopping cart item.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

SSL data to/from webcatalog? (2000) WebCatalog can't find database (1997) emailer error 452 (2001) change the number format (1997) select multiple (1997) WebCatalog sales (1997) More on the email templates (1997) SiteGuard Admin Feature ? (1997) [WebDNA] Databases not staying open (2010) [solved] WebDNA 5.1 and Mac OS X Server v10.3 - Working ??? (2003) Listserver problem (1997) HELP! Search finding too much! (1998) Multiple Merchant Accounts? (1997) My first ship table (1998) Shipping charges based on dollar level (1997) RE: shrink-wrapped version out yet? (1997) WebCatalog can't find database (1997) WebCatalog2 Feature Feedback (1996) WebCat2b12 - nesting [tags] (1997) syntax question, not in online refernce (1997)