Re: Unit Cost Look Up

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37180
interpreted = N
texte = Stephen Russo wrote: > > I have three choices for shipping: > > UPS Ground > UPS 2Day > UPS Next Day > > My products all contain an unitshipcost. Those Items that have a 10 in > unitshipcost can only be sent via UPS Ground. I want to be able to check if > one of the items in the users cart has a 10 in the unitshipcost then they > only have the option of UPS Ground. I did the following and it works except > if they add another item to the cart that does not have a 10 in > unitshipcost. > What you are doing is not going to work for you, because you are testing a single number versus a potentially multivalued field. Say you have two line items with unitshipcost of 10 and 5, then [lineitems][unitshipcost][/lineitems]will be literally 105so that is not what you want.I would recommend that you loop through each of the ShoppingCart lines and limit __shipvia if you find any that are Ground only. Like this (not tested):...top of page...[text]Ground_Only=[/text] [lineitems] [if [unitshipcost]=10] [text]Ground_Only=T [/if] [/lineitems]...later... Shipping Method: -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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:

    
  1. Re: Unit Cost Look Up (John Peacock 2001)
  2. Re: Unit Cost Look Up (Christer Olsson 2001)
  3. Unit Cost Look Up (Stephen Russo 2001)
Stephen Russo wrote: > > I have three choices for shipping: > > UPS Ground > UPS 2Day > UPS Next Day > > My products all contain an unitshipcost. Those Items that have a 10 in > unitshipcost can only be sent via UPS Ground. I want to be able to check if > one of the items in the users cart has a 10 in the unitshipcost then they > only have the option of UPS Ground. I did the following and it works except > if they add another item to the cart that does not have a 10 in > unitshipcost. > What you are doing is not going to work for you, because you are testing a single number versus a potentially multivalued field. Say you have two line items with unitshipcost of 10 and 5, then [lineitems][unitshipcost][/lineitems]will be literally 105so that is not what you want.I would recommend that you loop through each of the ShoppingCart lines and limit __shipvia if you find any that are Ground only. Like this (not tested):...top of page...[text]Ground_Only=[/text] [lineitems] [if [unitshipcost]=10] [text]Ground_Only=T [/if] [/lineitems]...later... Shipping Method: -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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/ John Peacock

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:

Can this be done? (1997) when is date system date or order date? (1997) Showif, Hideif reverse logic ? (1997) Robert Minor duplicate mail (1997) ListFiles (1998) TCPConnect and SSL servers (2001) Emailer setup (1997) Sort Order on a page search (1997) emailer (1997) Emailed problem (2000) Serving images from databases (1998) Re:Can anyone help me with this shipping thing? (1998) RE: Formulas.db + Users.db (1997) embedding [showcart] ??? (1998) POST through TCPConnect (1999) WebCat2 - Getting to the browser's username/password data (1997) This list needs a digest: rant, rave... (1997) Extended [ConvertChars] (1997) [numFound] inside [showIf]? (2000) Searching multiple fields from one form field (1997)