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:
XML parse with online xml-file + ampersant problem (2003)
WebCatalog/Mac 2.1b2 New Features (1997)
WebCat2 - [SendNews] (1997)
Protect and Serve (1999)
can WC render sites out? (1997)
Some Advise needed (1997)
[WebDNA] paypal (2009)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
taxrate - off by 1 cent (1997)
HTML Editors (1997)
triggers.db (1999)
listfields for a table (2007)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Missing Cart Information (2003)
Comments in db? (1997)
Bug Report, maybe (1997)
Bug Report, maybe (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
[WebDNA] shopping sites and the "old commerce tags" (2012)
Need relative path explanation (1997)