[WebDNA] Prices being changed

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107482
interpreted = N
texte = --Apple-Mail-1--1042011958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, I'm stumped on this one. Prices are being changed when added to the = shopping cart file by tenths of a cent and I'm not using any price = override. I expect a rip in the fabric of time and space next. (sorry = watching too much Dr. Who) =09 L57140FF00= Lei (Exotic)= =09 L39125.004FF0= = =09 L47120.004FF0= = = =09 See the second and third line item. 20.004. The 4 is the 4 from 40 = from line item one. If line item is $60 then two and three would be = .006. I only caught that as a shopping cart was showing 25.01 or $20.01 = in some cases. When I looked in the shopping cart file I saw the price = change. Interesting also, if I change the price in the database from = 40.00 to 40, loose the two zeros, and then do another purchase the price = shows up as 2540.00. Again adding on the price of the main item. I am using a form to submit the main item, say a gift basket for $40. = Then you can add on additional items say a box of chocolates, = strawberries etc for 25. When I look at the variables [formvariables] passed to the shopping cart = template the amounts are correct. So I guess the problem must be in the = following code, which is really just copied and pasted from from the = store builder. Can anyone help my poor eyes and tell me what is going on and how to = correct it. This just seems impossible. Thank you. 6.2 OSX, and Windows 2000, confirmed on both machines. Frank [showif [action]=3Dadd] [addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][sku][/url]]quantit= y=3D[qty]&textb=3D0&textc=3D[textc]&textd=3D[textd]&texte=3D[texte]&textf=3D= [textf][/addlineitem] [text]addedLineItem=3D[sku][/text] [!] Add all the related skus to the cart as well [/!] [formvariables name=3D---&exact=3DF] [addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][value][/url]][form= variables name=3D^[value]|&exact=3DF]Text[lookup = db=3D../store/data/categories.db&lookinfield=3DC_ID&value=3D[middle = startafter=3D|&endbefore=3D][name][/middle]&returnfield=3DC_CART]=3D[url][= value][/url]&[/formvariables][/addlineitem] [/formvariables] [/showif] --Apple-Mail-1--1042011958 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Hi,

I'm stumped on this one. Prices are being = changed when added to the shopping cart file by tenths of a cent and I'm = not using any price override.  I expect a rip in the fabric of time = and space next. (sorry watching too much Dr. = Who)

=
L57140FF00Lei = (Exotic)= = 
L391= 25.004= F= F= 0= = =
L47120.004FF= 0= = =
See the second and third line item. =  20.004.  The 4 is the 4 from 40 from line item one.  If = line item is $60 then two and three would be .006.  I only caught = that as a shopping cart was showing 25.01 or $20.01 in some cases. =  When I looked in the shopping cart file I saw the price change. = Interesting also, if I change the price in the database from 40.00 to = 40, loose the two zeros, and then do another purchase the price shows up = as 2540.00.  Again adding on the price of the main = item.

I am using a form to submit the main = item, say a gift basket for $40.  Then you can add on additional = items say a box of chocolates, strawberries etc for = 25.

When I look at the variables = [formvariables] passed to the shopping cart template the amounts are = correct. So I guess the problem must be in the following code, which is = really just copied and pasted from from the store = builder.

Can anyone help my poor eyes and tell = me what is going on and how to correct it.  This just seems = impossible.

Thank you.
6.2 OSX, = and Windows 2000, confirmed on both = machines.

Frank
[showif = [action]=3Dadd]
[addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][sku][/url]= ]quantity=3D[qty]&textb=3D0&textc=3D[textc]&textd=3D[textd]&am= p;texte=3D[texte]&textf=3D[textf][/addlineitem]
[text]addedL= ineItem=3D[sku][/text]


[!] Add = all the related skus to the cart as well [/!]
[formvariables = name=3D---&exact=3DF]
[addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][value][/ur= l]][formvariables name=3D^[value]|&exact=3DF]Text[lookup = db=3D../store/data/categories.db&lookinfield=3DC_ID&value=3D[middl= e = startafter=3D|&endbefore=3D][name][/middle]&returnfield=3DC_CART]=3D= [url][value][/url]&[/formvariables][/addlineitem]
[/formvari= ables]


[/showif]
<= br>

= --Apple-Mail-1--1042011958-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] Prices being changed (frank@cwolfe.com 2011)
--Apple-Mail-1--1042011958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, I'm stumped on this one. Prices are being changed when added to the = shopping cart file by tenths of a cent and I'm not using any price = override. I expect a rip in the fabric of time and space next. (sorry = watching too much Dr. Who) =09 L57140FF00= Lei (Exotic)= =09 L39125.004FF0= = =09 L47120.004FF0= = = =09 See the second and third line item. 20.004. The 4 is the 4 from 40 = from line item one. If line item is $60 then two and three would be = .006. I only caught that as a shopping cart was showing 25.01 or $20.01 = in some cases. When I looked in the shopping cart file I saw the price = change. Interesting also, if I change the price in the database from = 40.00 to 40, loose the two zeros, and then do another purchase the price = shows up as 2540.00. Again adding on the price of the main item. I am using a form to submit the main item, say a gift basket for $40. = Then you can add on additional items say a box of chocolates, = strawberries etc for 25. When I look at the variables [formvariables] passed to the shopping cart = template the amounts are correct. So I guess the problem must be in the = following code, which is really just copied and pasted from from the = store builder. Can anyone help my poor eyes and tell me what is going on and how to = correct it. This just seems impossible. Thank you. 6.2 OSX, and Windows 2000, confirmed on both machines. Frank [showif [action]=3Dadd] [addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][sku][/url]]quantit= y=3D[qty]&textb=3D0&textc=3D[textc]&textd=3D[textd]&texte=3D[texte]&textf=3D= [textf][/addlineitem] [text]addedLineItem=3D[sku][/text] [!] Add all the related skus to the cart as well [/!] [formvariables name=3D---&exact=3DF] [addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][value][/url]][form= variables name=3D^[value]|&exact=3DF]Text[lookup = db=3D../store/data/categories.db&lookinfield=3DC_ID&value=3D[middle = startafter=3D|&endbefore=3D][name][/middle]&returnfield=3DC_CART]=3D[url][= value][/url]&[/formvariables][/addlineitem] [/formvariables] [/showif] --Apple-Mail-1--1042011958 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Hi,

I'm stumped on this one. Prices are being = changed when added to the shopping cart file by tenths of a cent and I'm = not using any price override.  I expect a rip in the fabric of time = and space next. (sorry watching too much Dr. = Who)

=
L57140FF00Lei = (Exotic)= = 
L391= 25.004= F= F= 0= = =
L47120.004FF= 0= = =
See the second and third line item. =  20.004.  The 4 is the 4 from 40 from line item one.  If = line item is $60 then two and three would be .006.  I only caught = that as a shopping cart was showing 25.01 or $20.01 in some cases. =  When I looked in the shopping cart file I saw the price change. = Interesting also, if I change the price in the database from 40.00 to = 40, loose the two zeros, and then do another purchase the price shows up = as 2540.00.  Again adding on the price of the main = item.

I am using a form to submit the main = item, say a gift basket for $40.  Then you can add on additional = items say a box of chocolates, strawberries etc for = 25.

When I look at the variables = [formvariables] passed to the shopping cart template the amounts are = correct. So I guess the problem must be in the following code, which is = really just copied and pasted from from the store = builder.

Can anyone help my poor eyes and tell = me what is going on and how to correct it.  This just seems = impossible.

Thank you.
6.2 OSX, = and Windows 2000, confirmed on both = machines.

Frank
[showif = [action]=3Dadd]
[addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][sku][/url]= ]quantity=3D[qty]&textb=3D0&textc=3D[textc]&textd=3D[textd]&am= p;texte=3D[texte]&textf=3D[textf][/addlineitem]
[text]addedL= ineItem=3D[sku][/text]


[!] Add = all the related skus to the cart as well [/!]
[formvariables = name=3D---&exact=3DF]
[addlineitem = cart=3D[cart]&db=3D../store/data/tearoom.db&sku=3D[url][value][/ur= l]][formvariables name=3D^[value]|&exact=3DF]Text[lookup = db=3D../store/data/categories.db&lookinfield=3DC_ID&value=3D[middl= e = startafter=3D|&endbefore=3D][name][/middle]&returnfield=3DC_CART]=3D= [url][value][/url]&[/formvariables][/addlineitem]
[/formvari= ables]


[/showif]
<= br>

= --Apple-Mail-1--1042011958-- frank@cwolfe.com

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:

BUG in [showif] using ^ (contains) (1997) OT : Site speed feedback (2002) [WebDNA] how to purge webdna cache of templates? (2009) Calculating multiple shipping... (1997) typhoon ? (2003) Emailer setup (1997) searching with groups (1997) Webcat issue (2006) WebMerchant when CC network is down (1998) Add - optional parameters textA=.... (1997) OT: JavaScript question (2001) Online reference (1997) shownext example (2001) [WriteFile] problems (1997) [WebDNA] Apache 2 httpd.conf Question (2008) access denied problem (1997) Major bug report on rootbeer (1997) Separate SSL Server (1997) Snake Bites (1997) Line items in table cells (1997)