On Tue, 2002-06-18 at 16:57, Todd Wade wrote: > Felix Geerinckx wrote: > > > on Tue, 18 Jun 2002 19:11:29 GMT, Kevin Old wrote: > > > >> I have quite a complicated question and it is mainly about how to > >> process the data after I get it out of the database. > >> [...] > >> I need to perform caclulations on the values as they come out of the > >> database....does anyone know of a way to automate this. > > > > Did you consider performing the calculations within your SQL-statement, > > like e.g. > > > > SELECT a, b, a+b from atable > > > > This is the correct way to do it. Put the calculation logic in the SQL > statement. The only thing I can add here is to use the AS directive: > > SELECT a, b, a+b AS sum FROM table; > > Creates a virtual field "sum" in the recordset. > > Todd W.
This is of vital importance if you use fetchrow_hashref. -- Today is Prickle-Prickle the 23rd day of Confusion in the YOLD 3168 Wibble. Missile Address: 33:48:3.521N 84:23:34.786W -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
