<% function formatDec(n, d){
with (Math) {
// Separate the sign from the number
var sign = (n < 0) ? "-" : "";
var num = abs(n);
// Separate whole number from decimal
var whole = floor(num);
var frac = round((num - whole) * pow(10,d)).toString();
}
// Zero-fill decimal
for ( ; frac.length < d ; ) frac = "0" + frac;
// Put it all back together
return sign + whole + "." + frac;
}
var priceCounter = 0.00
%>
Thumbnail
Title
Quantity
Update
Remove
Price
<% var addShip
addShip = 0
var con = Server.CreateObject("ADODB.Connection");
con.Open(zmConn);
var rs = Server.CreateObject("ADODB.Recordset");
var zmSQL = "SELECT tblSectionDetails.CatID, tblProductDetails.Price, tblProductDetails.Title, tblPurchases.PurchaseID, tblPurchases.SessionID, tblPurchases.Image, tblPurchases.PhotoID, tblPurchases.Message, tblPurchases.Message2, tblPurchases.Quantity, tblProductDetails.Icon, tblProductDetails.ProductID FROM tblSectionDetails, tblProductDetails, tblPurchases WHERE tblProductDetails.ProductID = tblPurchases.ProductID AND tblPurchases.SessionID = " + Session.sessionID + " AND tblPurchases.Complete = 1 AND tblProductDetails.SectionID = tblSectionDetails.SectionID"
rs.Open(zmSQL, con, adOpenKeyset, adLockOptimistic);
if(rs.EOF){%>