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 :Don 11/6/03 1:40 PM, Mark Derrick at mark.derrick@computerwarehouse.co.ukwrote:> > 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:
Nice one...Thanks Mark :Don 11/6/03 1:40 PM, Mark Derrick at mark.derrick@computerwarehouse.co.ukwrote:> > 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)