I have to agree at least if you store in metrics you will ever only have to convert it once, when you are displaying it. Though this inherently loses some accuracy, it is exponentially worse if you have to convert a conversion
On Wed, Dec 2, 2009 at 1:45 PM, fly2279 <[email protected]> wrote: > I agree that metric would be much easier to convert but therein lies > the problem. Every time you convert from the user input of imperial to > metric you lose some accuracy in the total inventory. I guess I just > need to use the smallest unit to store it in the table and then > convert when inventory is added/subtracted. > > Are there any good tutorials/examples on methods to add/subtract > inventory? Should I be using a 'transactions' table and total those > transactions to come up with a quantity on hand or will that get out > of control with thousands of rows? > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
