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:

Running 2 two WebCatalog.acgi's (1996) [WebDNA] [text scope=global] (2014) all records returned. (1997) [OT] SMTP gateway software for Mac (1999) PIXO support (1997) typhoon... (1997) shownext not showing next...still r2 (1997) Faxing orders in place of email (1997) Support ?? (1997) Extended [ConvertChars] (1997) Anyone with a solution for this? (2001) Return records from another (1997) Emailer setup (1997) Still ignoring the 3.x bugs? (2000) FM PRO Compatibility Issue - Single Database w/o Conversions (1997) how to post without certain data appearing in the html source (2001) extending webcatalog (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Unique Sort (2003) HomePage Caution (1997)