Re: Orderfile Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53856
interpreted = N
texte = Nice one... Thanks Mark :D on 11/6/03 1:40 PM, Mark Derrick at mark.derrick@computerwarehouse.co.uk wrote: > > On 6 Nov 2003, at 13:33, Alan White wrote: > >> on 11/6/03 1:06 PM, Mark Derrick at >> mark.derrick@computerwarehouse.co.uk >> wrote: >> >>>> 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. >> >> So on the following page I would just use something like:- >> >> [text]zone=[lookup >> db=countries.db&value=[shiptocountry]&lookinfield=shiptocountry&returnf >> ield= >> zone][/text] >> >> [SetHeader cart=[cart]]header11=[zone][/SetHeader] >> >> Thanks >> Alan >> > > Yup, that looks like it will work fine. > Although you might want to rename the Text variable to stop getting > confused with the field name of the same name. > > > 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/ ------------------------------------------------------------- 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)
Nice one... Thanks Mark :D on 11/6/03 1:40 PM, Mark Derrick at mark.derrick@computerwarehouse.co.uk wrote: > > On 6 Nov 2003, at 13:33, Alan White wrote: > >> on 11/6/03 1:06 PM, Mark Derrick at >> mark.derrick@computerwarehouse.co.uk >> wrote: >> >>>> 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. >> >> So on the following page I would just use something like:- >> >> [text]zone=[lookup >> db=countries.db&value=[shiptocountry]&lookinfield=shiptocountry&returnf >> ield= >> zone][/text] >> >> [SetHeader cart=[cart]]header11=[zone][/SetHeader] >> >> Thanks >> Alan >> > > Yup, that looks like it will work fine. > Although you might want to rename the Text variable to stop getting > confused with the field name of the same name. > > > 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/ ------------------------------------------------------------- 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/ Alan White

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:

Problems passing [SKU] with $Replace in 2.0 (1997) Thanks Grant (1997) [HIDEIF] inside [FOUNDITEM] (1997) Multiple download orders of the same product? (1997) carriage returns in data (1997) the dreaded unitShipCost (2003) Exclude by date - multiple (1997) If search results are blank... (2003) Problem displaying search result (1997) OT: Safari/Mac - frames and iframes acting weird (2007) PCS Frames (1997) emailer (1997) Running _every_ page through WebCat ? (1997) Latest compatible Apache (2006) Protect (1997) unsubscribe (1997) [delete] problem (1997) Country & Ship-to address & other fields ? (1997) Error: this shopping cart has already been submittedm (2004) Help name our technology! I found it (1997)