Re: Filemaker Pro Template for Orders
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25047
interpreted = N
texte = another method, which I use, is to capture all the main data into an orders.db with the key field being the cart number (OrderID), while capturing all the lineitem data for that order into another db called lineitems.db which has the key field also using the same OrderID. So when you want to display an order in yoru admin template, you just search the orders.db for the record with that OrderID, and in the middle of that 'display' is another search context which finds all the records in lineitems.db having that same OrderID. make sense? :-) -JohnNitai wrote:> Timothy W. Killian @ evlist@eventure.com wrote: > > > [/lineitems]. So, I tried to place this within the [append] context like > > this: > > > > &purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal] > > I am using tons of [append]'s on my thankyou page. > > I use this to make it work. > > [lineitems] > > [append > db=somedb.db]ordernumber=[cart]&email=[__email]&produktnumber=[sku]&produkt= > [TextA]&send=F[/append] > > [/lineitems] > > Works and no problems so far. > > Sincerely, > Nitai > > -- > Over 7000 products in our Online Store. Hard- & Software, DVD, and more. > Mactrade - http://mactrade.ch/ > > EMail: Info@mactrade.ch > Tel: +41 (0)52 / 654 15 55, Fax: +41 (0)52 / 654 15 59 > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to
. > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
another method, which I use, is to capture all the main data into an orders.db with the key field being the cart number (OrderID), while capturing all the lineitem data for that order into another db called lineitems.db which has the key field also using the same OrderID. So when you want to display an order in yoru admin template, you just search the orders.db for the record with that OrderID, and in the middle of that 'display' is another search context which finds all the records in lineitems.db having that same OrderID. make sense? :-) -JohnNitai wrote:> Timothy W. Killian @ evlist@eventure.com wrote: > > > [/lineitems]. So, I tried to place this within the [append] context like > > this: > > > > &purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal] > > I am using tons of [append]'s on my thankyou page. > > I use this to make it work. > > [lineitems] > > [append > db=somedb.db]ordernumber=[cart]&email=[__email]&produktnumber=[sku]&produkt= > [TextA]&send=F[/append] > > [/lineitems] > > Works and no problems so far. > > Sincerely, > Nitai > > -- > Over 7000 products in our Online Store. Hard- & Software, DVD, and more. > Mactrade - http://mactrade.ch/ > > EMail: Info@mactrade.ch > Tel: +41 (0)52 / 654 15 55, Fax: +41 (0)52 / 654 15 59 > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
John Butler
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:
[include] affect on filepaths for links? (1997)
Adding up weights (1998)
Serial Number Question (1997)
Protecting webdelivery (1997)
Express Lane (2000)
Email (1998)
Check Boxes (2000)
SKU (1997)
[shownext] and descending order (1997)
select multiple (1997)
forming a SKU (1999)
A better WebCat whois (was [OT] Domain Name Scam) (2000)
WebDNA Solutions ... sorry! (1997)
Secure server question (1997)
Unexpected error (1997)
Electronic Delivery (1997)
Frames and WebCat (1997)
[include ...] behavior (1997)
Insert Line Feed Character (2004)
OS X permissions to write to Globals directory (2003)