Re: Orderfile Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53854
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
where to put code (1998)
BadSuffix with 2.1b3 cgi (1997)
searching for items that begin with a number (2004)
[format] problems (1998)
Robert Minor duplicate mail (1997)
Mondo amounts of Mail [long] (1999)
I can help! (1996)
WebCatalog Beta Documentation (1997)
Shipping Help! (1998)
Date Question (2002)
Change in Host? (1999)
How far do [showif]s go? (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Append command(2) (2000)
Single Link browsing (1997)
Mac & Internet Explorer (2000)
Secure server question (1997)
WebCat hosting providers? - one more option (1997)
Workaround for Emailer doubled bcc messages (1998)
WebDNA Solutions ... sorry! (1997)