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:
docs for WebCatalog2 (1997)
RE: Credit card processing - UK (1997)
WebCatalog Technical Reference (1997)
WebCatalog2 Feature Feedback (1996)
absolute paths for databases? (1997)
question: back button prevention (1997)
[format 40s]text[/format] doesn't work (1997)
[WebDNA] [BULK] The WebDAV Server Module / web services (2012)
WebCat2b13MacPlugIn - syntax to convert date (1997)
problem (1998)
WebCatalog for Postcards ? (1997)
Part 2 - [showif] if variable exists (1998)
Emailer Set Up (1997)
two unique banners on one page (1997)
WCS Newbie question (1997)
More questions about serial number dishing (1997)
name-value pairs (2006)
[math date] with non-US date format (2000)
Three new problems, maybe a fourth (1997)
dates and hex formatting (1997)