Re: Orderfile Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53852
interpreted = N
texte = On 6 Nov 2003, at 12:56, Alan White wrote: > Afternoon folks. > > I have a small question for you all... well smallish ;-) > > I am trying to build a 3 phase purchase area for our site where the > flow is > like this:- > > * User first enters Personal Details and Shipping Info > * User Enters Card holder and Card Details > * Invoice page and confirm order. > > Now on my first page I want to remove the choice of shipping zone and > do it > automatically by storing the countries in a database along with > shipping > zone like so... > > countryID country zone > 1 United Kingdom (Mainland) 1 > 2 Australia (DDP) 3 > 3 Italy (DDP) 2 > > I am however slightly confused now because I want to store the > shiptocountry > in the order file but I also want to be able to ascertain what the > zone is > going to be so I can set *HEADER11*. This is currently done using two > completely different fields, a textbox for shiptocountry and radio > boxes for > ship zone. > > Is it possible to see what the orderfile has stored (shiptocountry) > and then > do a lookup in my countries database to find my zone so I can set > HEADER11? > If this is not the case can somebody please suggest another method of > rolling both fields on information into one selection? > > Hope you can help. > > Alan > On the following page, do a lookup based on the "ShipToCountry" and then use a SETHEADER to add "Zone" to the order file. Mark. ------------------------------------------------------------- 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: Orderfile Question ( Alan White 2003)
  2. Re: Orderfile Question ( Donovan Brooke 2003)
  3. Re: Orderfile Question ( Alan White 2003)
  4. Re: Orderfile Question ( Mark Derrick 2003)
  5. Re: Orderfile Question ( Alan White 2003)
  6. Re: Orderfile Question ( Mark Derrick 2003)
  7. Orderfile Question ( Alan White 2003)
On 6 Nov 2003, at 12:56, Alan White wrote: > Afternoon folks. > > I have a small question for you all... well smallish ;-) > > I am trying to build a 3 phase purchase area for our site where the > flow is > like this:- > > * User first enters Personal Details and Shipping Info > * User Enters Card holder and Card Details > * Invoice page and confirm order. > > Now on my first page I want to remove the choice of shipping zone and > do it > automatically by storing the countries in a database along with > shipping > zone like so... > > countryID country zone > 1 United Kingdom (Mainland) 1 > 2 Australia (DDP) 3 > 3 Italy (DDP) 2 > > I am however slightly confused now because I want to store the > shiptocountry > in the order file but I also want to be able to ascertain what the > zone is > going to be so I can set *HEADER11*. This is currently done using two > completely different fields, a textbox for shiptocountry and radio > boxes for > ship zone. > > Is it possible to see what the orderfile has stored (shiptocountry) > and then > do a lookup in my countries database to find my zone so I can set > HEADER11? > If this is not the case can somebody please suggest another method of > rolling both fields on information into one selection? > > Hope you can help. > > Alan > On the following page, do a lookup based on the "ShipToCountry" and then use a SETHEADER to add "Zone" to the order file. Mark. ------------------------------------------------------------- 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/ Mark Derrick

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:

Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) .. more on sliding discounts... (1997) Review comparison by PC Magazine: Open for On-line Business (1997) WCS Newbie question (1997) Multiple download orders of the same product? (1997) security (https) w webcat (1999) Custom WebCat Prefs ... (1997) [OT] sbox error (2003) How to archive....? (1998) Error Log with Linux? (2000) If statement troubles (2002) OT: javascript help (2003) [WebDNA] fileinfo question (2016) Resume Catalog ? (1997) synching databases on multiple servers (1997) [convertchars] limits (1998) Help please.... trouble with a [text] showing (2000) [ReturnRaw] and hiding FORM data (2003) Part Html part WebDNA (1997) Price problem (1997)