|
dzirkelb1 -> RE: do NOT print something on page (2/27/2009 15:58:00)
|
My CSS skills are 0...so could you show me how to add it into this page?
<!-- #include file="dbQS.asp" -->
<%
strPONumber = request.querystring("PONumber")
ssql = "DELETE FROM RcvgLabels"
dbc.execute(ssql)
ssql = "INSERT INTO RcvgLabels ( [PO Number], [Part #], [Qty Recd], [DEE ORDER #], Customer, [Mfg Name], ID, Locator, CUSTNAME, [PO #], INSPECT )"
ssql = ssql & " SELECT PORECGS1.[PO Number], INVENTORYMASTER1.[Part #], PORECGS1.[Qty Recd], PORECGS1.[DEE ORDER #], PORECGS1.Customer, INVENTORYMASTER1.[Mfg Name], INVENTORYMASTER1.ID, INVENTORYMASTER1.Locator, PORECGS1.Customer AS CUSTNAME, PORECGS1.[PO Number] AS [PO #], INVENTORYMASTER1.INSPECT"
ssql = ssql & " FROM INVENTORYMASTER1 INNER JOIN PORECGS1 ON INVENTORYMASTER1.[Part #] = PORECGS1.[Part #]"
ssql = ssql & " WHERE (PORECGS1.[PO Number] = '"&strPONumber&"') AND (PORECGS1.TAG <> 0)"
dbc.execute(ssql)
ssql = "UPDATE PORECGS1 SET TAG = 0 WHERE (TAG <> 0) AND ([PO Number] = '"&strPONumber&"')"
dbc.execute(ssql)
set rs = server.CreateObject("adodb.Recordset")
ssql = "SELECT ID, [Part #] AS Part, [Mfg Name] AS Mfg, CUSTNAME, [PO #] AS PO, [DEE ORDER #] AS OrderNum, ID, INSPECT"
ssql = ssql & " FROM RcvgLabels"
rs.Open ssql, dbc, adOpenForwardOnly,adLockReadOnly
set rs1 = server.CreateObject("adodb.Recordset")
ssql = "SELECT OH, OO FROM INVENTORYMASTER1 WHERE ([Part #] = '"&rs("Part")&"')"
rs1.Open ssql, dbc, adOpenForwardOnly,adLockReadOnly
if not rs1.eof then
intOH = rs1("OH")
intOO = rs1("OO")
end if
rs1.close
set rs1=nothing
set rs1 = server.CreateObject("adodb.Recordset")
ssql = "SELECT [Qty Recd] AS QtyReceived FROM PORECGS1 WHERE ([PO Number] = '"&strPONumber&"')"
rs1.Open ssql, dbc, adOpenForwardOnly,adLockReadOnly
if not rs1.eof then
intQtyReceived = rs1("QtyReceived")
end if
rs1.close
set rs1=nothing
intOH = intOH + intQtyReceived
intOO = intOO - intQtyReceived
ssql = "UPDATE INVENTORYMASTER1 SET OH = "&intOH&", OO = "&intOO&" WHERE ([PART #] = '"&rs("Part")&"')"
dbc.execute(ssql)
%>
<html>
<head>
<title>Print Receiving Label</title>
</head>
<body>
<object classid="clsid:0C3874AA-AB39-4B5E-A768-45F3CE6C6819" id="BarCode1" width="116" height="28">
<param name="_cx" value="6000">
<param name="_cy" value="2000">
<param name="Enabled" value="-1">
<param name="AutoSize" value="0">
<param name="BackColor" value="16777215">
<param name="Font" value="Arial">
<param name="ForeColor" value="0">
<param name="SymbologyId" value="13">
<param name="DataToEncode" value="<%=rs("ID")%>">
<param name="Orientation" value="0">
<param name="BarHeight" value=".5">
<param name="NarrowBarWidth" value="0.05">
<param name="Wide2NarrowRatio" value="3">
<param name="AddCheckDigit" value="1">
<param name="AddCheckDigitToText" value="1">
<param name="Code128CharSet" value="0">
<param name="UPCESystem" value="0">
<param name="EANUPCSupplement" value="0">
<param name="ShowText" value="0">
<param name="TopMarginCM" value="0.06">
<param name="LeftMarginCM" value="0.1">
<param name="CodabarStartCharacter" value="A">
<param name="CodabarStopCharacter" value="B">
<param name="SupplementToEncode" value>
<param name="FixedResolutionCM" value="0">
<param name="ApplyTilde" value="1">
<param name="XDimensionMILS" value="11.81">
<param name="CharacterGrouping" value="0">
<param name="WhiteBarIncrease" value="0">
<param name="BearerBarHorizontal" value="0">
<param name="BearerBarVertical" value="0">
<param name="TextMarginCM" value="0.03">
<param name="PostnetHeightTallBar" value="0.3">
<param name="PostnetHeightShortBar" value="0.125">
</object>
<br>
<font face="arial" style="font-size: 8pt"><b>
<%=rs("Part")%>
<br>
<br>
<%=rs("Mfg")%>
<br>
<%=rs("CustName")%>
<br>
<%=rs("PO")%> <%=rs("OrderNum")%> <%=rs("ID")%> <%=rs("Inspect")%>
</b></font>
<br>
<font face="verdana" size="3"><a href="Receiving.asp">Back to Receiving</a></font>
</body>
<%
rs.close
set rs=nothing
dbc.close
set dbc=nothing
%></html>
I need this to not print: <br> <font face="verdana" size="3"><a href="Receiving.asp">Back to Receiving</a></font>
|
|
|
|