Re: [subtotal] problems -- help?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16521
interpreted = N
texte = >I see one problem with this that may help (but I haven't tried it since I >don't have your databases). The returnField in a lookup should be >price2, not [price2]. > >price [lookup >db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif >[SpecialID]^101]price2[/showif][showif >[SpecialID]^221]price3[/showif][showif >[SpecialID]^334]price4[/showif][showif [SpecialID]^445]price5[/showif]] > >I'm also concerned about the accuracy of the [SpecialID]^101 comparison. >What if that >101 appears somewhere else futher down the text of SpecialID?Grant-YOU ARE THE MAN! =-) That did fix the problem, it now works perfectly. The SpecialID only consists of a letter and three digits, so for most users there is no way that it could mess up. The other part that they need for access is a specific account number which is generated for them when they request for a Wholesale Price Sheet. We are not overly concerned about security, but rather would like each retailer to know that they are getting pricing that is specific to them.Thank you SO MUCH!-josh ------------------------ Technical Support Center The EnviroLink Network http://www.envirolink.org/support/Ph: 412-683-6400 Fx: 412-683-8460The EnviroLink Network is membership-supported 501(c)(3) non-profit organization. If you would like to help support our work, please consider becoming a member: http://www.envirolink.org/membership Associated Messages, from the most recent to the oldest:

    
  1. Re: [subtotal] problems -- help? (Technical Support 1998)
  2. Re: [subtotal] problems -- help? (Grant Hulbert 1998)
  3. [subtotal] problems -- help? (Technical Support 1998)
>I see one problem with this that may help (but I haven't tried it since I >don't have your databases). The returnField in a lookup should be >price2, not [price2]. > >price [lookup >db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif >[SpecialID]^101]price2[/showif][showif >[SpecialID]^221]price3[/showif][showif >[SpecialID]^334]price4[/showif][showif [SpecialID]^445]price5[/showif]] > >I'm also concerned about the accuracy of the [SpecialID]^101 comparison. >What if that >101 appears somewhere else futher down the text of SpecialID?Grant-YOU ARE THE MAN! =-) That did fix the problem, it now works perfectly. The SpecialID only consists of a letter and three digits, so for most users there is no way that it could mess up. The other part that they need for access is a specific account number which is generated for them when they request for a Wholesale Price Sheet. We are not overly concerned about security, but rather would like each retailer to know that they are getting pricing that is specific to them.Thank you SO MUCH!-josh ------------------------ Technical Support Center The EnviroLink Network http://www.envirolink.org/support/Ph: 412-683-6400 Fx: 412-683-8460The EnviroLink Network is membership-supported 501(c)(3) non-profit organization. If you would like to help support our work, please consider becoming a member: http://www.envirolink.org/membership Technical Support

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:

[WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012) Deleting Multiple Database Records based on Checkbox (1998) inside out... how much? (2004) Problem with summary on date / inconsequent webcat behaviour (1998) Banners (1997) Tip O' the Week (1996) Cookie Crumble (1998) Error Messges (1997) Not really WebCat (1997) Pull Down Search (2000) listfiles-looking for slick solution (1997) woops - speed results - right subject (2002) ShowNext (1997) [convertchars] limits (1998) Formulas.db not working (2006) OT - royalty free images (2002) Search inside Include (1998) Location of Webcat site in folder hierarchy (1997) HTML Editors (1997) is sku a REQUIRED field on NT (1997)