Re: Orderfile Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53853
interpreted = N
texte = 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&returnfield= zone][/text] [SetHeader cart=[cart]]header11=[zone][/SetHeader] Thanks Alan ------------------------------------------------------------- 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 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&returnfield= zone][/text] [SetHeader cart=[cart]]header11=[zone][/SetHeader] Thanks Alan ------------------------------------------------------------- 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:

[HIDEIF] inside [FOUNDITEM] (1997) Where is f2? (1997) ErrorMessages.db suggestion (1997) Signal Raised (1997) Email Attachments (1998) Setting up shop (1997) Permission Denied Error (2001) Unstable on my server (2000) tracking no. of downloads (2006) emailer setup (1997) searchable list archive (1997) [URL] around a [sendmail] recipient? - SEARCHING: command vs. context (2000) How do I make this faster???? (2000) Does it use the two Processors ? (1999) Text Variabels Not Passed To Include (2002) Fwd: mondomail and Webcat (2000) WebDNA deletes major DB data big time (2004) search confusing me (2008) WC2f3 (1997) [Sum] function? (1997)