Country & Ship-to address & other fields ?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10290
interpreted = N
texte = Hi, I'm back for more :-)Since we ship internationally and we also allow a ship-to addresses which may be different from the billing addresses: Where is the logical place to store this information within the current database structure (WebCatalog & WebMerchant) ?It isn't yet clear to us if we are restricted to using the fields listed as required or reserved or if we can come up with our own fields which are accessible from .tmpl to .tmpl and can also be passed on to WebMerchant ? In addition to the normal name and address fields, we'd need- Country - Fax number - Ship-to name - Ship-to company - Ship-to address 1 - Ship-to address 2 - Ship-to city - Ship-to state or province - Ship-to zip or postal code - Ship-to country - Resale # (tax exempt) - Purchase Order number - Requisition number - How did you hear about us fieldYou get the idea, there are quite a few :-)If we can define our own, where do we define them and/or store them ? Is there a separate database or text file where the standard and new fields are defined and stored ?Thanks, -Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California _____________________________________________________________________ Associated Messages, from the most recent to the oldest:

    
  1. [BULK] Re: [WebDNA] API Code - IP to Country code and zip Code to us census (2000) (Jym Duane 2011)
  2. [WebDNA] API Code - IP to Country code and zip Code to us census (2000) (David Bastedo 2011)
  3. Re: Dynamic Form - Shipping Country / State/ Province ( "Bess Ho" 2006)
  4. Re: Dynamic Form - Shipping Country / State/ Province ( Marc Thompson 2006)
  5. Re: Dynamic Form - Shipping Country / State/ Province ( Ki Song 2006)
  6. Re: Dynamic Form - Shipping Country / State/ Province ( "Bess Ho" 2006)
  7. Re: Dynamic Form - Shipping Country / State/ Province ( "Bess Ho" 2006)
  8. Re: Dynamic Form - Shipping Country / State/ Province ( Donovan Brooke 2006)
  9. Re: Dynamic Form - Shipping Country / State/ Province ( Marc Thompson 2006)
  10. Re: Dynamic Form - Shipping Country / State/ Province ( Ki Song 2006)
  11. Re: Dynamic Form - Shipping Country / State/ Province ( John Peacock 2006)
  12. Dynamic Form - Shipping Country / State/ Province ( Ki Song 2006)
  13. UPS online tools Country code error ( sal danna 2005)
  14. Re: country of origin from IPADDRESS??? (Donovan Brooke 2001)
  15. Re: country of origin from IPADDRESS??? (John Peacock 2001)
  16. Re: country of origin from IPADDRESS??? (dale 2001)
  17. Re: country of origin from IPADDRESS??? (Alain Russell 2001)
  18. Re: country of origin from IPADDRESS??? (Andrew Simpson 2001)
  19. Re: country of origin from IPADDRESS??? (Alain Russell 2001)
  20. Re: country of origin from IPADDRESS??? (Andrew Simpson 2001)
  21. Re: country of origin from IPADDRESS??? (Clint Davis 2001)
  22. Re: country of origin from IPADDRESS??? (Bob Minor 2001)
  23. Re: country of origin from IPADDRESS??? (Andrew Simpson 2001)
  24. Re: country of origin from IPADDRESS??? (Alain Russell 2001)
  25. Re: country of origin from IPADDRESS??? (Dale Therio 2001)
  26. Re: country of origin from IPADDRESS??? (Andrew Simpson 2001)
  27. Re: country of origin from IPADDRESS??? (Alain Russell 2001)
  28. Re: country of origin from IPADDRESS??? (Andrew Simpson 2001)
  29. Re: country of origin from IPADDRESS??? (Alain Russell 2001)
  30. country of origin from IPADDRESS??? (Andrew Simpson 2001)
  31. Re: Country & Ship-to address & other fields ? (Dean Smith 1997)
  32. Re: Country & Ship-to address & other fields ? (Sven U. Grenander 1997)
  33. Re: Country & Ship-to address & other fields ? (Grant Hulbert 1997)
  34. Re: Country & Ship-to address & other fields ? (jason@globax.com (Jason Wallace) 1997)
  35. Re: Country & Ship-to address & other fields ? (Grant Hulbert 1997)
  36. Re: Country & Ship-to address & other fields ? (Grant Hulbert 1997)
  37. Country & Ship-to address & other fields ? (Sven U. Grenander 1997)
Hi, I'm back for more :-)Since we ship internationally and we also allow a ship-to addresses which may be different from the billing addresses: Where is the logical place to store this information within the current database structure (WebCatalog & WebMerchant) ?It isn't yet clear to us if we are restricted to using the fields listed as required or reserved or if we can come up with our own fields which are accessible from .tmpl to .tmpl and can also be passed on to WebMerchant ? In addition to the normal name and address fields, we'd need- Country - Fax number - Ship-to name - Ship-to company - Ship-to address 1 - Ship-to address 2 - Ship-to city - Ship-to state or province - Ship-to zip or postal code - Ship-to country - Resale # (tax exempt) - Purchase Order number - Requisition number - How did you hear about us fieldYou get the idea, there are quite a few :-)If we can define our own, where do we define them and/or store them ? Is there a separate database or text file where the standard and new fields are defined and stored ?Thanks, -Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California _____________________________________________________________________ Sven U. Grenander

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:

Adding multiple items to Cart at one time, & append context problem (1998) Where's Cart Created ? (1997) formatting dates from a field ... (1997) RE: Problems with dbcatalog.exe (1997) Kaaaaahhhhhhhnnnnnnn! (1997) ShrPAUL1@aol.com has been banned (2000) Customizing WebDelivery.html (1998) Trouble serving graphics on protected templates (1998) I give up!! (1997) Emailer (1997) Custom Shipping Charges (1997) New Server? (2006) Order not created error (1997) math a various prices (1997) Multiple servers and Webcat (1998) [sendmail] and [formvariables] (1997) Problem with updating to 2.1.1 (1998) WebCatalog for guestbook ? (1997) shownext (1997) WebCat.acgi from /cgi-bin/? (1997)