Hi,
I am creating a code that will multiply the quantity amount selected to
the cost of the product, which will ultimately give me a total. I can't
find an example of code that multiplies table datas to give me a total.
I've looked through all of the books, but there is no example of how to
multiply this. Any help would be greatly appreciated! Here is my
current code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!---Form for Orders--->
<!---Need to do a query in order to pull information for multiplying--->
<cfquery name="sales" datasource="store">
SELECT *
WHERE Sales
</cfquery>
<html>
<head>
<title>Order Form</title>
</head>
<body>
<CFFORM action="orderformtemp.cfm" method="post">
<table>
<tr><td size="10" div
align="left"><STRONG>Products</STRONG></td><td><STRONG>Description</STRONG></td><td><STRONG>Size</STRONG></td><td><STRONG>Cost</STRONG></td><td><STRONG>Quantity</STRONG></td><td><STRONG>Total</STRONG></td></tr>
<tr><td></td><td><EM>Dog Treats</EM> </td></tr>
<tr><td>Ark Naturals</td><td>Beef Jerky with Glucosamine added to help
with Hip and Joints</td><td>9 0z. Package</td><td>$12.49</td><td><SELECT
Name="Quantity" Size=1>
<OPTION VALUE="1" selected>1
<OPTION VALUE="2">2
<OPTION VALUE="3">3
<OPTION VALUE="4">4
<OPTION VALUE="5">5</OPTION>
</SELECT>
</td>
<td><CFINPUT required="no" NAME="Ark" size="5"
maxlength="5"></td>
</tr>
</table>
</CFFORM>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
