<%@ LANGUAGE=JSCRIPT %>
<%
var dt = Server.CreateObject("ADODB.Connection");
dt.Open ("spares","root","cromemco");
var dt1 = Server.CreateObject("ADODB.Connection");
dt1.Open ("orders","root","cromemco");
var pmpNr=Request.QueryString("sn")(1);
var ln=Request.QueryString("ln")(1);
var nme=Request.QueryString("n")(1);
var SQL= "insert into view_log (user, time_stamp, pumpNr, pmp_txt, list_nr) values ('"+Request.ServerVariables("AUTH_USER")+"','"+new Date()+"','"+pmpNr+"','"+nme+"','"+ln+"')";
dt1.Execute(SQL);
SQL="SELECT a.POS_NR, a.QUANTITY, a.TOT_JM, b.V_D, b.SPR_NR, b.SPR_TXT1, b.SPR_TXT2, c.CROLIST FROM pmpspr a INNER JOIN SPR b ON a.SPR_NR=b.SPR_NR INNER JOIN PRICES c ON a.SPR_NR=c.SPR_NR WHERE a.PMP_NR='"+pmpNr+"' and pos_nr <>8888 and pos_nr>0 ORDER BY POS_NR";
var rs=dt.Execute(SQL);
function formatPrice (p) {
var m=formatPriceValue(p);
var i=Math.floor(m);
var d=Math.round((m-i)*100);
if (d<10) {
d='0'+d;
}
return i+","+d;
}
function formatPriceValue (p) {
var q=Math.round(p*100)/100;
return q;
}
%>
Spare parts of product <%=nme%>