Re: !@#$$@@# formulas database, tax and freight.
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43050
interpreted = N
texte = That would make far to much sense for Andrew ;) > Why not just set the cart number into the cookie and when the person returns > to the site use a getcookie to set the cart #. > > This is how we make sites remember the users. > > > > > ----- Original Message ----- > From: Andrew Simpson
> To: WebCatalog Talk > Sent: Sunday, September 01, 2002 5:00 PM > Subject: Re: !@#$$@@# formulas database, tax and freight. > > >> yeah - I went through all this malarky the first time I coded the store. >> >> I ended up putting taxable = T in the formulas database and that is meant > to >> overide everything. >> >> You can't set taxable in the addlineitem unless you supply the password as >> it is similar to changing the price of the items in the cart. we weren't > too >> keen on the idea of supplying the password. >> >> anyway - taxable and freight is picked up alright by the first code and > not >> by the second and I still fail to see the difference and why one would act >> differently to another. >> >> >> >> ----- Original Message ----- >> From: Stuart Tremain >> To: WebCatalog Talk >> Sent: Monday, September 02, 2002 11:46 AM >> Subject: Re: !@#$$@@# formulas database, tax and freight. >> >> >>> I had the same problem recently. >>> >>> It may be that you also need to pass a password in the addlineitems: >>> >>> >>> [LineItems][AddLineItem >> > file=repeatorders/[cart]&sku=[sku]&db=../data/directproducts.db]password=You >> > rPassword&Quantity=[Quantity]&Taxable=[Taxable]&TextA=[TextA]&TextB=[TextB]& >> TextC=[TextC]&TextD=[TextD]&TextE=[TextE][/AddLineItem] [/LineItems] >>> >>> The password is in wour webcat prefs. >>> >>> >>> >>> >>> >>> -- >>> Stuart Tremain >>> idfk web developments - Australia >>> >>> On Monday, 2 September 2002, Andrew Simpson >> wrote: >>>> A site we did is trying to be clever in that it remembers what you had > in >>>> your cart from visit to visit. >>>> >>>> If you add something to your cart then close your browser, open your >> browser >>>> and come back again. the item is magically restored. >>>> >>>> The way it works is i store a temporary customer ID in a cookie and > write >>>> the products to a database. If the customer comes back i loop through > all >>>> the products in the database and add them back in to a new >>>> cart. >>>> >>>> My problem however is that when i add the products programatically, the >> tax >>>> and freight from the formulas database are ignored. >>>> >>>> What i can't understand is the code that adds the line item the first >> time >>>> around is identical to the code the re-adds the products from >>>> the database. >>>> >>>> What am i missing? >>>> >>>> Do i have to set some headers before or after i add line items to > invoke >> the >>>> formulas database? >>>> Do i have to use setlineitems rather than addlineitems? >>>> do i have to do a rain dance to make this mickey mouse technology work >> the >>>> way i expect everytime??? >>>> >>>> code that adds line item and works correctly: >>>> [!]***Everything okay?***[/!] >>>> [showif [add_a_lineYN]=YES] >>>> [text]price_error_msg=Sorry, we do not currently have a price for > that >>>> product. You are welcome to call and find out more about its >>>> availability.[/text] >>>> [text]show_price_error=YES[/text] >>>> [hideif [LOOKUP >>> >> >> db=/db/products.db&value=[SKU]&lookInField=SKU&returnField=PRICE¬Found=] >> = >>>> ] >>>> [text]show_price_error=NO[/text] >>>> [AddLineItem >>>> cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem] >>>> [/hideif] >>>> [/showif] >>>> >>>> code that re-adds line item and doesn't work. >>>> [!]*** Order can exist under either the customer ID if the user has a >>>> profile or under the cart as an order ID ***[/!] >>>> [!]*** If they are a logged in user - do it this way as there may > be >>>> more than one order under this cust_id and it would be good to clear it >> all >>>> up ***[/!] >>>> [showif [user_logged_in]=TRUE] >>>> [search >>>> db=/db/existing_order.db&eqCUST_IDdatarq=[logged_user_id]&max=1] >>>> [founditems] >>>> [search >>> >> >> db=/db/existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1 >> & >>>> LINE_IDtype=number] >>>> [founditems] >>>> [AddLineItem >>> >> cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/AddLineItem] >>>> [/founditems] >>>> [/search] >>>> [/founditems] >>>> [/search] >>>> [/showif] >>>> >>>> help? >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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 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 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 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 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:
That would make far to much sense for Andrew ;) > Why not just set the cart number into the cookie and when the person returns > to the site use a getcookie to set the cart #. > > This is how we make sites remember the users. > > > > > ----- Original Message ----- > From: Andrew Simpson > To: WebCatalog Talk > Sent: Sunday, September 01, 2002 5:00 PM > Subject: Re: !@#$$@@# formulas database, tax and freight. > > >> yeah - I went through all this malarky the first time I coded the store. >> >> I ended up putting taxable = T in the formulas database and that is meant > to >> overide everything. >> >> You can't set taxable in the addlineitem unless you supply the password as >> it is similar to changing the price of the items in the cart. we weren't > too >> keen on the idea of supplying the password. >> >> anyway - taxable and freight is picked up alright by the first code and > not >> by the second and I still fail to see the difference and why one would act >> differently to another. >> >> >> >> ----- Original Message ----- >> From: Stuart Tremain >> To: WebCatalog Talk >> Sent: Monday, September 02, 2002 11:46 AM >> Subject: Re: !@#$$@@# formulas database, tax and freight. >> >> >>> I had the same problem recently. >>> >>> It may be that you also need to pass a password in the addlineitems: >>> >>> >>> [lineitems][AddLineItem >> > file=repeatorders/[cart]&sku=[sku]&db=../data/directproducts.db]password=You >> > rPassword&Quantity=[Quantity]&Taxable=[Taxable]&TextA=[TextA]&TextB=[TextB]& >> TextC=[TextC]&TextD=[TextD]&TextE=[TextE][/AddLineItem] [/LineItems] >>> >>> The password is in wour webcat prefs. >>> >>> >>> >>> >>> >>> -- >>> Stuart Tremain >>> idfk web developments - Australia >>> >>> On Monday, 2 September 2002, Andrew Simpson >> wrote: >>>> A site we did is trying to be clever in that it remembers what you had > in >>>> your cart from visit to visit. >>>> >>>> If you add something to your cart then close your browser, open your >> browser >>>> and come back again. the item is magically restored. >>>> >>>> The way it works is i store a temporary customer ID in a cookie and > write >>>> the products to a database. If the customer comes back i loop through > all >>>> the products in the database and add them back in to a new >>>> cart. >>>> >>>> My problem however is that when i add the products programatically, the >> tax >>>> and freight from the formulas database are ignored. >>>> >>>> What i can't understand is the code that adds the line item the first >> time >>>> around is identical to the code the re-adds the products from >>>> the database. >>>> >>>> What am i missing? >>>> >>>> Do i have to set some headers before or after i add line items to > invoke >> the >>>> formulas database? >>>> Do i have to use setlineitems rather than addlineitems? >>>> do i have to do a rain dance to make this mickey mouse technology work >> the >>>> way i expect everytime??? >>>> >>>> code that adds line item and works correctly: >>>> [!]***Everything okay?***[/!] >>>> [showif [add_a_lineYN]=YES] >>>> [text]price_error_msg=Sorry, we do not currently have a price for > that >>>> product. You are welcome to call and find out more about its >>>> availability.[/text] >>>> [text]show_price_error=YES[/text] >>>> [hideif [LOOKUP >>> >> >> db=/db/products.db&value=[SKU]&lookInField=SKU&returnField=PRICE¬Found=] >> = >>>> ] >>>> [text]show_price_error=NO[/text] >>>> [AddLineItem >>>> cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem] >>>> [/hideif] >>>> [/showif] >>>> >>>> code that re-adds line item and doesn't work. >>>> [!]*** Order can exist under either the customer ID if the user has a >>>> profile or under the cart as an order ID ***[/!] >>>> [!]*** If they are a logged in user - do it this way as there may > be >>>> more than one order under this cust_id and it would be good to clear it >> all >>>> up ***[/!] >>>> [showif [user_logged_in]=TRUE] >>>> [search >>>> db=/db/existing_order.db&eqCUST_IDdatarq=[logged_user_id]&max=1] >>>> [founditems] >>>> [search >>> >> >> db=/db/existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1 >> & >>>> LINE_IDtype=number] >>>> [founditems] >>>> [AddLineItem >>> >> cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/AddLineItem] >>>> [/founditems] >>>> [/search] >>>> [/founditems] >>>> [/search] >>>> [/showif] >>>> >>>> help? >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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 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 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 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 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/
Alain Russell
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:
Some Questions (1997)
OT: IP addres checking (2003)
A quickie question (1997)
Search/sort in URL Was: GuestBook example (1997)
how do ye do this?????? (2001)
weening me off overwriting form variables. John Peacock? (2000)
my price won't move (1997)
Discounts (1998)
Nested tags count question (1997)
Superfilous Characters (1998)
[OT] maximum POST variable size (2007)
all records returned. (1997)
Client-side Image Maps and WebCat? (1998)
available times? (2003)
Stopping bad HTML propagation ? (1997)
Not really WebCat - need HTML Grider (1997)
Make sure I understand this??? (1997)
Another webcatalog site!! (1997)
Looking for a special Image Upload Script (2004)
Re2: frames & carts (1997)