Posted by Hugo Kornelis on 08/29/05 01:56

On 26 Aug 2005 12:29:36 -0700, fwells11@hotmail.com wrote:

(snip)
>Problem:
>
>I would like to be able to keep a running percentage total in a field
>associated with my users.

Hi fwells11,

Don't. The basic idea of a databsae is that you don't store information
that can be computed from other information; you compute it whenever you
need it. There are exceptions to this rule (mainly performance-related),
but I don't think your case is one of them.

John already gave you a suggestion. If that doesn't work for you, then
post table structure (as CREATE TABLE statements), sample data (as
INSERT statements) and expected output and I'll see if I can help you
further (note - I can only help you with a MS SQL Server solution, as I
don't speak MySQL).

John already mentioned www.aspfaq.com/5006, so I won't repeat that.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]