Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Simple calculation

Simple calculation

Thread began 7/04/2009 11:46 pm by Russell Collins | Last modified 7/07/2009 5:09 am by Russell Collins | 1461 views | 2 replies |

7/04/2009 11:46 pm | #1 russell355191Beta Tester

Simple calculation

Hi,

I am creating an assets management app at the moment and am not sure what to do in order for a total to be put into a DA input field. Could I possibly use an eCart object?

Field 1 has the unit cost
Field 2 has the qty
In field 3 I would like a total automatically calculated as unit cost x qty to be inserted on submit.

Any pointers or help would be much appreciated.

Regards

Russ

7/06/2009 7:59 am | #2 Ray BorduinWebAssist

You probably don't need a cart.

First, you probably don't want to insert into field3. If field3 by definition is equal to field1*field2, then storing it at all is just an opportunity for an error. Just store field1 and field2 in the database and if you want to use all three use a query like:

SELECT *, (field1 * field2) AS field3 FROM table

and even though you only stored field1 and field2 you can always get the value of field3 in your results.

Did this help? Tips are appreciated...

7/07/2009 5:09 am | #3 russell355191Beta Tester

Thanks

Thanks Ray,

You are the spark that lights the fire!

Go WebAssist !

Regards
Russell Collins

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.