how do i get price * quantity = total in database?<BR>do i do this in sql or do i do it in asp?<BR><BR>if in sql, how can i get it to automatically get total price and fill in the total column?
defaults are nice<BR>or a trigger in sql server.<BR><BR>
select (price * quantity) as total<BR>where....<BR><BR><BR>i think that'll do it
will i be able to store the value to the field in DB?
Do you already have the price and quantity stored in the database? If so, why do you need to store the total too?<BR><BR>Or are the price and quantity coming from a form or something?