Re: Storing Data
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45519
interpreted = N
texte = EricOnce a cart has been completed [PURCHASE cart=cartID]Putting [PURCHASE cart=cartID] in your template moves the specified shopping cart file from the ShoppingCarts folder to the Orders folder, effectively the same as a Purchase command. If the cart file is not in a ShoppingCarts folder, you may use the alternate file=/folder/cartID instead of cart=cartIDIf you are now trying to access the cart file from WebMerchant you will probably need to do it like this:[Orderfile cart=orders/[cart]][header40][/Orderfile]This will depend on how your system is setup.Have a look in your orders directory, you can look at the contents of the cart file by opening it in a text editor.On Wednesday, November 20, 2002, at 12:51 PM, Eric wrote:> Dear Brian:>> Thanks for the suggestion.>> I put this>> [setheader cart=[cart]]header40=[BW][/setheader]> in the invoice.inc file>> I then put the following in the WebMerchant/AdminResults.inc file>> [Orderfile cart=[cart]]> [header40]> [/Orderfile]>> But it gives the following error message:>> Error: Can't open order file. Ignoring [OrderFile] context>>> What did I do wrong?>>> Regards,>> Eric>>> At 12:29 PM 11/19/2002 -0800, you wrote:>> You can store your BW value in one of the order file headers - >> header1 - header40 - then recall it from within any direct or implied >> orderfile context. Something like:>>>> [setheader cart=[cart]]header20=[BW][/setheader]>>>> will set it. To access the value, just use [header20] inside an >> orderfile context.>>>> Note: Once you go down the road of using the header1-40 fields in the >> order file, it is extremely important to document and keep track of >> what header you use for what purpose.>>>> - brian>>>> At 12:09 PM -0600 11/19/02, Eric wrote:>>> Hi,>>>>>> I have the following working in the invoice.inc file:>>>>>> [math show=F]BW=0[lineitems]+[lookup >>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]>>>>>> The Calculated data is stored in [BW] in the invoice.inc file and I >>> can use the stored data anywhere in the invoice.inc file.>>>>>> My question is:>>>>>> How can I store the data so that I can call and use the data stored >>> in [BW] to be used in the WebMerchant/AdminResults.inc file?>>>>>> I tried but it shows zero value.>>>>>> I even put the following in the AdminResults.inc file>>>>>> [math show=F]BW=0[lineitems]+[lookup >>> db=../admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]>>>>>> and it still shows a zero value.>>>>>> Thanks,>>>>>> Eric>>>> ------------------------------------------------------------->> 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://search.smithmicro.com/>>>> -->> This message has been scanned for viruses and>> dangerous content by MailScanner, and is>> believed to be clean.>> ow3>>>>>> -->> This message has been scanned for viruses and>> dangerous content by MailScanner, and is>> believed to be clean.>> ow3>>>> -------------------------------------------------------------> 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://search.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
EricOnce a cart has been completed [PURCHASE cart=cartID]Putting [PURCHASE cart=cartID] in your template moves the specified shopping cart file from the ShoppingCarts folder to the Orders folder, effectively the same as a Purchase command. If the cart file is not in a ShoppingCarts folder, you may use the alternate file=/folder/cartID instead of cart=cartIDIf you are now trying to access the cart file from WebMerchant you will probably need to do it like this:[Orderfile cart=orders/[cart]][header40][/Orderfile]This will depend on how your system is setup.Have a look in your orders directory, you can look at the contents of the cart file by opening it in a text editor.On Wednesday, November 20, 2002, at 12:51 PM, Eric wrote:> Dear Brian:>> Thanks for the suggestion.>> I put this>> [setheader cart=[cart]]header40=[BW][/setheader]> in the invoice.inc file>> I then put the following in the WebMerchant/AdminResults.inc file>> [Orderfile cart=[cart]]> [header40]> [/Orderfile]>> But it gives the following error message:>> Error: Can't open order file. Ignoring [orderfile] context>>> What did I do wrong?>>> Regards,>> Eric>>> At 12:29 PM 11/19/2002 -0800, you wrote:>> You can store your BW value in one of the order file headers - >> header1 - header40 - then recall it from within any direct or implied >> orderfile context. Something like:>>>> [setheader cart=[cart]]header20=[BW][/setheader]>>>> will set it. To access the value, just use [header20] inside an >> orderfile context.>>>> Note: Once you go down the road of using the header1-40 fields in the >> order file, it is extremely important to document and keep track of >> what header you use for what purpose.>>>> - brian>>>> At 12:09 PM -0600 11/19/02, Eric wrote:>>> Hi,>>>>>> I have the following working in the invoice.inc file:>>>>>> [math show=F]BW=0[lineitems]+[lookup >>> db=admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]>>>>>> The Calculated data is stored in [BW] in the invoice.inc file and I >>> can use the stored data anywhere in the invoice.inc file.>>>>>> My question is:>>>>>> How can I store the data so that I can call and use the data stored >>> in [BW] to be used in the WebMerchant/AdminResults.inc file?>>>>>> I tried but it shows zero value.>>>>>> I even put the following in the AdminResults.inc file>>>>>> [math show=F]BW=0[lineitems]+[lookup >>> db=../admin/products.db&lookinfield=SKU&value=[url][sku][/ >>> url]&returnfield=WEIGHT]*[quantity][/lineitems][/math]>>>>>> and it still shows a zero value.>>>>>> Thanks,>>>>>> Eric>>>> ------------------------------------------------------------->> 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://search.smithmicro.com/>>>> -->> This message has been scanned for viruses and>> dangerous content by MailScanner, and is>> believed to be clean.>> ow3>>>>>> -->> This message has been scanned for viruses and>> dangerous content by MailScanner, and is>> believed to be clean.>> ow3>>>> -------------------------------------------------------------> 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://search.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------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://search.smithmicro.com/
Stuart Tremain
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:
Order not created error (never mind) (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Signal Raised Error (Part II) (1997)
mySQL --- problem?? (2004)
Shopping Cart Problem (1998)
date format (another question) (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[WebDNA] WebDNA History (2012)
Can WC remember people? (1998)
Listserver problem (1997)
PIXO Support (1997)
Selling WebDNA as a solution (2003)
Parsing overhead for commenting out line endings (2003)
Template transformed itself into a database? (1998)
wc 2 pro users - sites, quotes wanted (1997)
Where is the bug fix info for 4.0.1? (2000)
Bad URL reference? (1997)
REDIRECT MULTIPLE RESULTS (2000)
Server capacity (2003)
WebCat2b15MacPlugin - showing [math] (1997)