Re: !@#$$@@# formulas database, tax and freight.
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43052
interpreted = N
texte = ignore Alain - he's suffering a bit today from a complete lack knowing whathe's talking about.the reason i didn't do it that way was because for a reasonably high trafficsite, it wouldn't make much sense to keep all the carts for each visitor. Wehave set webcat to sweep the carts directory every 24 hours. In saying thathowever, i do check to see if the old cart is still there and if it is,transfer the contents into the new cart.regardless - this is still not the problem.maybe webcat has issues with things being added to a cart a fraction of asecond after the cart was created?----- Original Message -----From: Alain Russell
To: WebCatalog Talk Sent: Monday, September 02, 2002 4:40 PMSubject: Re: !@#$$@@# formulas database, tax and freight.> That would make far to much sense for Andrew ;)>>> > Why not just set the cart number into the cookie and when the personreturns> > 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 thestore.> >>> >> I ended up putting taxable = T in the formulas database and that ismeant> > to> >> overide everything.> >>> >> You can't set taxable in the addlineitem unless you supply the passwordas> >> it is similar to changing the price of the items in the cart. weweren'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 wouldact> >> 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 youhad> > 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 technologywork> >> 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 clearit> >> 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/-------------------------------------------------------------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:
ignore Alain - he's suffering a bit today from a complete lack knowing whathe's talking about.the reason i didn't do it that way was because for a reasonably high trafficsite, it wouldn't make much sense to keep all the carts for each visitor. Wehave set webcat to sweep the carts directory every 24 hours. In saying thathowever, i do check to see if the old cart is still there and if it is,transfer the contents into the new cart.regardless - this is still not the problem.maybe webcat has issues with things being added to a cart a fraction of asecond after the cart was created?----- Original Message -----From: Alain Russell To: WebCatalog Talk Sent: Monday, September 02, 2002 4:40 PMSubject: Re: !@#$$@@# formulas database, tax and freight.> That would make far to much sense for Andrew ;)>>> > Why not just set the cart number into the cookie and when the personreturns> > 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 thestore.> >>> >> I ended up putting taxable = T in the formulas database and that ismeant> > to> >> overide everything.> >>> >> You can't set taxable in the addlineitem unless you supply the passwordas> >> it is similar to changing the price of the items in the cart. weweren'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 wouldact> >> 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 youhad> > 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 technologywork> >> 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 clearit> >> 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/-------------------------------------------------------------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/
Andrew Simpson
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:
PCS Frames (1997)
Download URL & access on the fly ? (1997)
Emailer (1997)
Decrypting a user password (2000)
WebCatalog 2.0.1 NT beta 1 released (1997)
4.0.1 behavior question (2000)
need help please (1997)
Showif Context combined with Search (1997)
HELP WITH DATES (1997)
checkbox results written to a database (1999)
Custom WebCat Prefs ... (1997)
'does not contain' operator needed ... (1997)
WebCat and WebTV (1997)
PROBLEM (1997)
What am I missing (1997)
Silly Question (1997)
WC1.6 to WC2 date formatting (1997)
comparison to Lasso 6 or 7 (2004)
Um. silly question perhaps...but I don't know, so I'm askin'.. (2001)
Customer - again (1998)