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:
How can I Add several Items into the cart at once? (1997)
Shipping cost out of synch (1998)
Still Stumped on ShowNext...HELP! (1997)
math problems (2000)
problems with 2 tags (1997)
Users.db (1998)
Creating a back button (1999)
Transfer of data from Invoice to thank you templates (1998)
Mac: LModelDirector bug fix (1997)
Opinion: [input] should be called [output] ... (1997)
faxing orders (2000)
Cookie set browser session. (1998)
CommandSecurity duplication? (2000)
Bug? (2000)
docs for WebCatalog2 (1997)
Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003)
Problem with version 4 browsers (1998)
Shipping Calc - done (1998)
[WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010)
What if SSL server down? MAC (1997)