Forums
This topic is locked
Update Not Working- Can't tell if its DW or me
Posted 27 May 2007 04:39:46
1
has voted
27 May 2007 04:39:46 Melissa Ferris posted:
I am trying to make an update page and a new record page, I have done this before and it has always worked fine. However I have noticed lately that DW is acting funny and putting things in right etc. I have been working on this same page for 3 days and I just can't get it to work. The error message is:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
and it points to the execute line.
I have already checked for restricted words and followed all those checks, but nothing so far has worked. I was wondering if someone with more experience might be able to spot the problem. The code is long, but I know you'll need it so here goes. With this one I used the dreamweaver update form to make it because I figured maybe I was messing up just using the update record function, but still more of the same. Thank you so much for any help you can give me.
Code:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/QFD.asp" -->
<%
' *** Edit Operations: declare variables
Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd
Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId
Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")
If (Request.QueryString <> "" Then
MM_editAction = MM_editAction & "?" & Request.QueryString
End If
' boolean to abort record edit
MM_abortEdit = false
' query string to execute
MM_editQuery = ""
%>
<%
' *** Update Record: set variables
If (CStr(Request("MM_update") = "form2" And CStr(Request("MM_recordId") <> "" Then
MM_editConnection = MM_QFD_STRING
MM_editTable = "Accessories"
MM_editColumn = "moldingid"
MM_recordId = "" + Request.Form("MM_recordId" + ""
MM_editRedirectUrl = ""
MM_fieldsStr = "Productid|value|Quarter_Round|value|Specs|value|Stock|value|Price|value|Dual_Reducer|value|DRSpecs|value|DRStock|value|DRPrice|value|Stair_Nose|value|SNSpecs|value|SNStock|value|SNPrice|value|Flush_Stair_Nose|value|FSNSpecs|value|FSNStock|value|FSNPrice|value|TMolding|value|TMSpecs|value|TMStock|value|TMPrice|value|Wall_Base|value|WBSpecs|value|WBStock|value|WBPrice|value|Reducer|value|RSpecs|value|RStock|value|RPrice|value|Square_Nose|value|SQNSpecs|value|SQNStock|value|SQNPrice|value|Threshold|value|TSpecs|value|TStock|value|TPrice|value|BaseShoe|value|BSSpecs|value|BSStock|value|BSPrice|value|Filler|value|FSpecs|value|FStock|value|FPrice|value|Overlap_Stair|value|OSSpecs|value|OSStock|value|OSPrice|value|Overlap_Reducer|value|ORSpecs|value|ORStock|value|ORPrice|value|TouchUp_Kit|value|TUKSpecs|value|TUKStock|value|TUKPrice|value|Nosing|value|NOSpecs|value|NOStock|value|NOPrice|value|Shoe_Molding|value|SMSpecs|value|SMStock|value|SMPrice|value|MultiPurpose_Reducer_W_Track|value|MPRSpecs|value|MPRStock|value|MPRPrice|value|TMolding_W_Track|value|TMTSpecs|value|TMTStock|value|TMTPrice|value|Baby_Threshold|value|BTSpecs|value|BTStock|value|BTPrice|value|Overlap_Stepnose_W_Track|value|OSWTSpecs|value|OSWTStock|value|OSWTPrice|value|Stair_Treads|value|STSpecs|value|STStock|value|STPrice|value|Floor_Vents|value|FVSpecs|value|FVStock|value|FVPrice|value|Reducer_Strip|value|RSSpecs|value|RSStock|value|RSPrice|value|Step_Down|value|SDSpecs|value|SDStock|value|SDPrice|value|FourInOne|value|I1Specs|value|I1Stock|value|I1Price|value|Sealant|value|SSpecs|value|SStock|value|SPrice|value|Finishing_Putty|value|FPSpecs|value|FPStock|value|FPPrice|value|Adaptor_Profile_Reducer_12x55|value|APRSpecs|value|APRStock|value|APRPrice|value|End_ProfileStair_Nose_14x36|value|EPSNSpecs|value|EPSNStock|value|EPSNPrice|value|Expansion_Profile_Reducer_12x46|value|EPRSpecs|value|EPRStock|value|EPRPrice|value|Incizo|value|ISpecs|value|IStock|value|IPrice|value|Stair_ProfileStair_Nose_20x65|value|SPSNSpecs|value|SPSNStock|value|SPSNPrice|value|QS_Sub_Profile_70|value|SP70Specs|value|SP70Stock|value|SP70Price|value|QS_Sub_Profile_80|value|SP80Specs|value|SP80Stock|value|SP80Price|value|QS_Sub_Profile_95|value|SP95Specs|value|SP95Stock|value|SP95Price|value|Quadra_SkirtingWall_Base|value|QSWBSpecs|value|QSWBStock|value|QSWBPrice|value|Quarter_Round_Skirting|value|QRSSpecs|value|QRSStock|value|QRSPrice|value|Install_Kit|value|IKSpecs|value|IKStock|value|IKPrice|value|Stair_Nose_Reducer|value|SNRSpecs|value|SNRStock|value|SNRPrice|value|Reducer_W_Clip|value|RWCSpecs|value|RWCStock|value|RWCPrice|value|TMolding_W_Clip|value|TMCSpecs|value|TMCStock|value|TMCPrice|value|Stair_Nose_W_Clip|value|SNCSpecs|value|SNCStock|value|SNCPrice|value|End_Cap|value|ECSpecs|value|ECStock|value|ECPrice|value|Transition_Strip|value|TSSpecs|value|TSStock|value|TSPrice|value|TExpansion|value|TESpecs|value|TEStock|value|TEPrice|value|Acoustic_Molding|value|AMSpecs|value|AMStock|value|AMPrice|value|Base_Board|value|BBSpecs|value|BBStock|value|BBPrice|value|Overlap_Step_Nose|value|OSNSpecs|value|OSNStock|value|OSNPrice|value|One_Step_Stair_Tread|value|SSTSpecs|value|SSTStock|value|SSTPrice|value|FausTrim_5_In_1|value|F5I1Specs|value|F5I1Stock|value|F5I1Price|value|NONEAVAIL|value|Stair_Riser|value|SRSpecs|value|SRStockNumber|value|SRPrice|value|Stair_Riser2|value|SR2Specs|value|SR2Stock|value|SR2Price|value|Floating_Reducer|value|FRStock|value|FRPrice|value|Glue_Reducer|value|GRStock|value|GRPrice|value|Flush_Reducer|value|FluRStock|value|FluRPrice|value|St_Nose_Floating|value|StNFloStock|value|StNFloPrice|value|St_Nose_Glue|value|StNGlStock|value|StNGlPrice|value|St_Nose_Flush|value|StNFluStock|value|StNFluPrice|value"
MM_columnsStr = "Productid|',none,''|Quarter_Round|none,1,0|Specs|',none,''|Stock#|',none,''|Price|none,none,NULL|Dual_Reducer|none,1,0|DRSpecs|',none,''|DRStock#|',none,''|DRPrice|none,none,NULL|Stair_Nose|none,1,0|SNSpecs|',none,''|SNStock#|',none,''|SNPrice|none,none,NULL|Flush_Stair_Nose|none,1,0|FSNSpecs|',none,''|FSNStock#|',none,''|FSNPrice|none,none,NULL|T-Molding|none,1,0|TMSpecs|',none,''|TMStock#|',none,''|TMPrice|none,none,NULL|Wall_Base|none,1,0|WBSpecs|',none,''|WBStock#|',none,''|WBPrice|none,none,NULL|Reducer|none,1,0|RSpecs|',none,''|RStock#|',none,''|RPrice|none,none,NULL|Square_Nose|none,1,0|SQNSpecs|',none,''|SQNStock#|',none,''|SQNPrice|none,none,NULL|Threshold|none,1,0|TSpecs|',none,''|TStock#|',none,''|TPrice|none,none,NULL|Base/Shoe|none,1,0|BSSpecs|',none,''|BSStock#|',none,''|BSPrice|none,none,NULL|Filler|none,1,0|FSpecs|',none,''|FStock#|',none,''|FPrice|none,none,NULL|Overlap_Stair|none,1,0|OSSpecs|',none,''|OSStock#|',none,''|OSPrice|none,none,NULL|Overlap_Reducer|none,1,0|ORSpecs|',none,''|ORStock#|',none,''|ORPrice|none,none,NULL|Touch-Up_Kit|none,1,0|TUKSpecs|',none,''|TUKStock#|',none,''|TUKPrice|none,none,NULL|Nosing|none,1,0|NOSpecs|',none,''|NOStock#|',none,''|NOPrice|none,none,NULL|Shoe_Molding|none,1,0|SMSpecs|',none,''|SMStock#|',none,''|SMPrice|none,none,NULL|Multi-Purpose_Reducer_W_Track|none,1,0|MPRSpecs|',none,''|MPRStock#|',none,''|MPRPrice|none,none,NULL|T-Molding_W_Track|none,1,0|TMTSpecs|',none,''|TMTStock#|',none,''|TMTPrice|none,none,NULL|Baby_Threshold|none,1,0|BTSpecs|',none,''|BTStock#|',none,''|BTPrice|none,none,NULL|Overlap_Stepnose_W_Track|none,1,0|OSWTSpecs|',none,''|OSWTStock#|',none,''|OSWTPrice|none,none,NULL|Stair_Treads|none,1,0|STSpecs|',none,''|STStock#|',none,''|STPrice|none,none,NULL|Floor_Vents|none,1,0|FVSpecs|',none,''|FVStock#|',none,''|FVPrice|none,none,NULL|Reducer_Strip|none,1,0|RSSpecs|',none,''|RSStock#|',none,''|RSPrice|none,none,NULL|Step_Down|none,1,0|SDSpecs|',none,''|SDStock#|',none,''|SDPrice|none,none,NULL|Four-In-One|none,1,0|4I1Specs|',none,''|4I1Stock#|',none,''|4I1Price|none,none,NULL|Sealant|none,1,0|SSpecs|',none,''|SStock#|',none,''|SPrice|none,none,NULL|Finishing_Putty|none,1,0|FPSpecs|',none,''|FPStock#|',none,''|FPPrice|none,none,NULL|Adaptor_Profile_Reducer_12x55|none,1,0|APRSpecs|',none,''|APRStock#|',none,''|APRPrice|none,none,NULL|End_Profile-Stair_Nose_14x36|none,1,0|EPSNSpecs|',none,''|EPSNStock#|',none,''|EPSNPrice|none,none,NULL|Expansion_Profile_Reducer_12x46|none,1,0|EPRSpecs|',none,''|EPRStock#|',none,''|EPRPrice|none,none,NULL|Incizo|none,1,0|ISpecs|',none,''|IStock#|',none,''|IPrice|none,none,NULL|Stair_Profile-Stair_Nose_20x65|none,1,0|SPSNSpecs|',none,''|SPSNStock#|',none,''|SPSNPrice|none,none,NULL|QS_Sub_Profile_70|none,1,0|SP70Specs|',none,''|SP70Stock#|',none,''|SP70Price|none,none,NULL|QS_Sub_Profile_80|none,1,0|SP80Specs|',none,''|SP80Stock#|',none,''|SP80Price|none,none,NULL|QS_Sub_Profile_95|none,1,0|SP95Specs|',none,''|SP95Stock#|',none,''|SP95Price|none,none,NULL|Quadra_Skirting-Wall_Base|none,1,0|QSWBSpecs|',none,''|QSWBStock#|',none,''|QSWBPrice|none,none,NULL|Quarter_Round_Skirting|none,1,0|QRSSpecs|',none,''|QRSStock#|',none,''|QRSPrice|none,none,NULL|Install_Kit|none,1,0|IKSpecs|',none,''|IKStock#|',none,''|IKPrice|none,none,NULL|Stair_Nose_Reducer|none,1,0|SNRSpecs|',none,''|SNRStock#|',none,''|SNRPrice|none,none,NULL|Reducer_W_Clip|none,1,0|RWCSpecs|',none,''|RWCStock#|',none,''|RWCPrice|none,none,NULL|T-Molding_W_Clip|none,1,0|TMCSpecs|',none,''|TMCStock#|',none,''|TMCPrice|none,none,NULL|Stair_Nose_W_Clip|none,1,0|SNCSpecs|',none,''|SNCStock#|',none,''|SNCPrice|none,none,NULL|End_Cap|none,1,0|ECSpecs|',none,''|ECStock#|',none,''|ECPrice|none,none,NULL|Transition_Strip|none,1,0|TSSpecs|',none,''|TSStock#|',none,''|TSPrice|none,none,NULL|T-Expansion|none,1,0|TESpecs|',none,''|TEStock#|',none,''|TEPrice|none,none,NULL|Acoustic_Molding|none,1,0|AMSpecs|',none,''|AMStock#|',none,''|AMPrice|none,none,NULL|Base_Board|none,1,0|BBSpecs|',none,''|BBStock#|',none,''|BBPrice|none,none,NULL|Overlap_Step_Nose|none,1,0|OSNSpecs|',none,''|OSNStock#|',none,''|OSNPrice|none,none,NULL|One_Step_Stair_Tread|none,1,0|1SSTSpecs|',none,''|1SSTStock#|',none,''|1SSTPrice|none,none,NULL|FausTrim_5_In_1|none,1,0|F5I1Specs|',none,''|F5I1Stock#|',none,''|F5I1Price|none,none,NULL|NONEAVAIL|none,1,0|Stair_Riser|none,1,0|SRSpecs|',none,''|SRStockNumber|',none,''|SRPrice|none,none,NULL|Stair_Riser2|none,1,0|SR2Specs|',none,''|SR2Stock#|',none,''|SR2Price|none,none,NULL|Floating_Reducer|none,1,0|FRStock#|',none,''|FRPrice|none,none,NULL|Glue_Reducer|none,1,0|GRStock#|',none,''|GRPrice|none,none,NULL|Flush_Reducer|none,1,0|FluRStock#|',none,''|FluRPrice|none,none,NULL|St_Nose_Floating|none,1,0|StNFloStock#|',none,''|StNFloPrice|none,none,NULL|St_Nose_Glue|none,1,0|StNGlStock#|',none,''|StNGlPrice|none,none,NULL|St_Nose_Flush|none,1,0|StNFluStock#|',none,''|StNFluPrice|none,none,NULL"
' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"
' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next
' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
End If
%>
<%
' *** Update Record: construct a sql update statement and execute it
If (CStr(Request("MM_update") <> "" And CStr(Request("MM_recordId") <> "" Then
' create the sql update statement
MM_editQuery = "update " & MM_editTable & " set "
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),","
MM_delim = MM_typeArray(0)
If (MM_delim = "none" Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none" Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none" Then MM_emptyVal = ""
If (MM_formVal = "" Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "" Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'" Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i <> LBound(MM_fields)) Then
MM_editQuery = MM_editQuery & ","
End If
MM_editQuery = MM_editQuery & MM_columns(MM_i) & " = " & MM_formVal
Next
MM_editQuery = MM_editQuery & " where " & MM_editColumn & " = " & MM_recordId
If (Not MM_abortEdit) Then
' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
End If
%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="index.asp"
MM_grantAccess=false
If Session("MM_Username" <> "" Then
If (true Or CStr(Session("MM_UserAuthorization")="" Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization")>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?" >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL"
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
<%
Dim mannav
Dim mannav_numRows
Set mannav = Server.CreateObject("ADODB.Recordset"
mannav.ActiveConnection = MM_QFD_STRING
mannav.Source = "SELECT manufacturerid, manufacturername FROM Manufacturers ORDER BY manufacturername ASC"
mannav.CursorType = 0
mannav.CursorLocation = 2
mannav.LockType = 1
mannav.Open()
mannav_numRows = 0
%>
<%
Dim coordinatingaccessories__MMColParam
coordinatingaccessories__MMColParam = "WODBUT3"
If (Request.QueryString("stocknumber" <> "" Then
coordinatingaccessories__MMColParam = Request.QueryString("stocknumber"
End If
%>
<%
Dim coordinatingaccessories
Dim coordinatingaccessories_numRows
Set coordinatingaccessories = Server.CreateObject("ADODB.Recordset"
coordinatingaccessories.ActiveConnection = MM_QFD_STRING
coordinatingaccessories.Source = "SELECT * FROM Accessories WHERE Productid = '" + Replace(coordinatingaccessories__MMColParam, "'", "''" + "'"
coordinatingaccessories.CursorType = 0
coordinatingaccessories.CursorLocation = 2
coordinatingaccessories.LockType = 1
coordinatingaccessories.Open()
coordinatingaccessories_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
mannav_numRows = mannav_numRows + Repeat1__numRows
%>
<html>
<head>
<title>Quality Floors Direct</title>
<meta name="generator" content="Namo WebEditor v5.0">
</head>
<body bgcolor="white" text="black" link="black" vlink="#666666" alink="#333333">
<table cellpadding="0" cellspacing="0" width="976" height="100">
<tr>
<td width="976" colspan="3" bgcolor="#9AA8A7" height="29"> <p align="right"><font face="Verdana" size="2"><b><a href="admin_index.asp">Admin
Home</a> | <a href="admin_aboutus.asp">About Us</a> |
<a href="contact.asp">Contact </a> | <a href="admin_gallery.asp">Flooring
Gallery</a> | <a href="admin_install_services.asp">Installation
Services</a> | <a href="customer_service.asp">Customer Service &
Information Center</a> </b></font></p>
</td>
</tr>
<tr height="100">
<td width="976" colspan="3" bgcolor="#CAB890" background="drkcremeback.png" height="100">
<div align="left">
<table cellpadding="0" cellspacing="0" height="100" width="976">
<tr>
<td width="645">
<p align="center"><img src="titleQFD.png" width="600" height="100" border="0"></p>
</td>
<td width="331" background="drkcremeback.png" bgcolor="#CAB98E"> <p align="right"><font size="2" face="Verdana">Email:
<br>
Phone: 1.888.70FLOOR </font>
<div align="right">
<table cellpadding="0" cellspacing="0" width="131">
<tr>
<td width="51">
<p align="center"><a href="www.cartmanager.net/cgi-bin/cart.cgi?UserLogin=sierra&CheckOut=Online&CartID=sierra"><img src="login2.png" border="0"></a></p>
</td>
<td width="80">
<p align="center"><form method=POST style="margin-bottom: 0" action="www.cartmanager.net/cgi-bin/cart.cgi">
<div align="center">
<input type=hidden name="ViewCart" value="sierra">
<input type=image src="file:///C|/Documents%20and%20Settings/Mander/Desktop/AWD/qualityfloorsdirect/cartiwthcirle2.png" width="45" height="45">
</div>
</form></font></p>
</td>
</tr>
<tr>
<td width="51" height="16">
<p align="center"><font face="Verdana" size="2"><b>Log
In</b></font></p>
</td>
<td width="80">
<p align="center"><font face="Verdana" size="2"><b>View
Cart</b></font></p>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
<div align="right">
</div>
</td>
</tr>
<tr>
<td width="976" colspan="3" bgcolor="#8B9A97" background="drkgreen.png" height="52">
<p align="center"><a href="admin_hardwood_floors.asp"><img src="hardwoodfloors2.png" width="154" height="41" border="0"></a><a href="admin_laminate_floors.asp"><img src="laminatefloors2.png" width="154" height="41" border="0"></a><a href="vinyl_floors.asp"><img src="luxuryvinyl2.png" width="154" height="41" border="0"></a><a href="admin_bamboo_floors.asp"><img src="bamboo2.png" width="154" height="41" border="0"></a><a href="admin_tools_accessories.asp"><img src="toolsandaccessories2.png" width="154" height="41" border="0"></a><a href="weekly_specials.asp"><img src="weeklyspecials2.png" width="154" height="41" border="0"></a></p>
</td>
</tr>
<tr>
<td width="211" bgcolor="#8B9A97" background="drkgreen.png" height="78">
<form name="form1">
<p align="center"><input type="text" name="formtext1" size="23"><br>
<input type="submit" name="formbutton1" value="Site Search"><br></p>
<p align="center"><img src="man.png" width="179" height="23" border="0">
<br>
<br>
<font size="3" face="Verdana, Arial, Helvetica, sans-serif"><a href="admin_newmanufacturer.asp"><font color="#000000" size="3" face="Verdana, Arial, Helvetica, sans-serif"><strong>+
Add Manufacturer</strong></font></a><br>
<font size="3" face="Verdana, Arial, Helvetica, sans-serif"><a href="admin_managesales_gallerys.asp">-
Manage Sale gallerys -</a></font><br>
<font size="3" face="Verdana, Arial, Helvetica, sans-serif"><a href="admin_managesales_Products.asp">-
Manage Sale Products -</a></font> </font>
</form>
</td>
<td width="765" height="621" rowspan="2" valign="top" colspan="2">
<p align="center"><font color="#8A9A99" size="5" face="Verdana, Arial, Helvetica, sans-serif"><strong>Title</strong></font></p>
<p align="center"> </p>
<form method="post" action="<%=MM_editAction%>" name="form2">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Productid:</td>
<td> <input type="text" name="Productid" value="<%=(coordinatingaccessories.Fields.Item("Productid".Value)%>" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Quarter_Round:</td>
<td> <input type="checkbox" name="Quarter_Round" value=1 <%If (CStr(coordinatingaccessories.Fields.Item("Quarter_Round".Value) = CStr("yes") Then Response.Write("checked" : Response.Write(""%>>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Specs:</td>
<td> <input type="text" name="Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stock#:</td>
<td> <input type="text" name="Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Price:</td>
<td> <input type="text" name="Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Dual_Reducer:</td>
<td> <input type="checkbox" name="Dual_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">DRSpecs:</td>
<td> <input type="text" name="DRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">DRStock#:</td>
<td> <input type="text" name="DRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">DRPrice:</td>
<td> <input type="text" name="DRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Nose:</td>
<td> <input type="checkbox" name="Stair_Nose" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNSpecs:</td>
<td> <input type="text" name="SNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNStock#:</td>
<td> <input type="text" name="SNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNPrice:</td>
<td> <input type="text" name="SNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Flush_Stair_Nose:</td>
<td> <input type="checkbox" name="Flush_Stair_Nose" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FSNSpecs:</td>
<td> <input type="text" name="FSNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FSNStock#:</td>
<td> <input type="text" name="FSNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FSNPrice:</td>
<td> <input type="text" name="FSNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">T-Molding:</td>
<td> <input type="checkbox" name="TMolding" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMSpecs:</td>
<td> <input type="text" name="TMSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMStock#:</td>
<td> <input type="text" name="TMStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMPrice:</td>
<td> <input type="text" name="TMPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Wall_Base:</td>
<td> <input type="checkbox" name="Wall_Base" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">WBSpecs:</td>
<td> <input type="text" name="WBSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">WBStock#:</td>
<td> <input type="text" name="WBStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">WBPrice:</td>
<td> <input type="text" name="WBPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Reducer:</td>
<td> <input type="checkbox" name="Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RSpecs:</td>
<td> <input type="text" name="RSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RStock#:</td>
<td> <input type="text" name="RStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RPrice:</td>
<td> <input type="text" name="RPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Square_Nose:</td>
<td> <input type="checkbox" name="Square_Nose" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SQNSpecs:</td>
<td> <input type="text" name="SQNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SQNStock#:</td>
<td> <input type="text" name="SQNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SQNPrice:</td>
<td> <input type="text" name="SQNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Threshold:</td>
<td> <input type="checkbox" name="Threshold" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TSpecs:</td>
<td> <input type="text" name="TSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TStock#:</td>
<td> <input type="text" name="TStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TPrice:</td>
<td> <input type="text" name="TPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Base/Shoe:</td>
<td> <input type="checkbox" name="BaseShoe" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BSSpecs:</td>
<td> <input type="text" name="BSSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BSStock#:</td>
<td> <input type="text" name="BSStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BSPrice:</td>
<td> <input type="text" name="BSPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Filler:</td>
<td> <input type="checkbox" name="Filler" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FSpecs:</td>
<td> <input type="text" name="FSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FStock#:</td>
<td> <input type="text" name="FStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FPrice:</td>
<td> <input type="text" name="FPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Overlap_Stair:</td>
<td> <input type="checkbox" name="Overlap_Stair" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSSpecs:</td>
<td> <input type="text" name="OSSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSStock#:</td>
<td> <input type="text" name="OSStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSPrice:</td>
<td> <input type="text" name="OSPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Overlap_Reducer:</td>
<td> <input type="checkbox" name="Overlap_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ORSpecs:</td>
<td> <input type="text" name="ORSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ORStock#:</td>
<td> <input type="text" name="ORStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ORPrice:</td>
<td> <input type="text" name="ORPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Touch-Up_Kit:</td>
<td> <input type="checkbox" name="TouchUp_Kit" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TUKSpecs:</td>
<td> <input type="text" name="TUKSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TUKStock#:</td>
<td> <input type="text" name="TUKStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TUKPrice:</td>
<td> <input type="text" name="TUKPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Nosing:</td>
<td> <input type="checkbox" name="Nosing" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">NOSpecs:</td>
<td> <input type="text" name="NOSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">NOStock#:</td>
<td> <input type="text" name="NOStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">NOPrice:</td>
<td> <input type="text" name="NOPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Shoe_Molding:</td>
<td> <input type="checkbox" name="Shoe_Molding" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SMSpecs:</td>
<td> <input type="text" name="SMSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SMStock#:</td>
<td> <input type="text" name="SMStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SMPrice:</td>
<td> <input type="text" name="SMPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Multi-Purpose_Reducer_W_Track:</td>
<td> <input type="checkbox" name="MultiPurpose_Reducer_W_Track" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">MPRSpecs:</td>
<td> <input type="text" name="MPRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">MPRStock#:</td>
<td> <input type="text" name="MPRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">MPRPrice:</td>
<td> <input type="text" name="MPRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">T-Molding_W_Track:</td>
<td> <input type="checkbox" name="TMolding_W_Track" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMTSpecs:</td>
<td> <input type="text" name="TMTSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMTStock#:</td>
<td> <input type="text" name="TMTStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMTPrice:</td>
<td> <input type="text" name="TMTPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Baby_Threshold:</td>
<td> <input type="checkbox" name="Baby_Threshold" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BTSpecs:</td>
<td> <input type="text" name="BTSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BTStock#:</td>
<td> <input type="text" name="BTStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BTPrice:</td>
<td> <input type="text" name="BTPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Overlap_Stepnose_W_Track:</td>
<td> <input type="checkbox" name="Overlap_Stepnose_W_Track" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSWTSpecs:</td>
<td> <input type="text" name="OSWTSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSWTStock#:</td>
<td> <input type="text" name="OSWTStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSWTPrice:</td>
<td> <input type="text" name="OSWTPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Treads:</td>
<td> <input type="checkbox" name="Stair_Treads" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">STSpecs:</td>
<td> <input type="text" name="STSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">STStock#:</td>
<td> <input type="text" name="STStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">STPrice:</td>
<td> <input type="text" name="STPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Floor_Vents:</td>
<td> <input type="checkbox" name="Floor_Vents" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FVSpecs:</td>
<td> <input type="text" name="FVSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FVStock#:</td>
<td> <input type="text" name="FVStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FVPrice:</td>
<td> <input type="text" name="FVPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Reducer_Strip:</td>
<td> <input type="checkbox" name="Reducer_Strip" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RSSpecs:</td>
<td> <input type="text" name="RSSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RSStock#:</td>
<td> <input type="text" name="RSStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RSPrice:</td>
<td> <input type="text" name="RSPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Step_Down:</td>
<td> <input type="checkbox" name="Step_Down" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SDSpecs:</td>
<td> <input type="text" name="SDSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SDStock#:</td>
<td> <input type="text" name="SDStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SDPrice:</td>
<td> <input type="text" name="SDPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Four-In-One:</td>
<td> <input type="checkbox" name="FourInOne" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">4I1Specs:</td>
<td> <input type="text" name="I1Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">4I1Stock#:</td>
<td> <input type="text" name="I1Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">4I1Price:</td>
<td> <input type="text" name="I1Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Sealant:</td>
<td> <input type="checkbox" name="Sealant" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SSpecs:</td>
<td> <input type="text" name="SSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SStock#:</td>
<td> <input type="text" name="SStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SPrice:</td>
<td> <input type="text" name="SPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Finishing_Putty:</td>
<td> <input type="checkbox" name="Finishing_Putty" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FPSpecs:</td>
<td> <input type="text" name="FPSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FPStock#:</td>
<td> <input type="text" name="FPStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FPPrice:</td>
<td> <input type="text" name="FPPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Adaptor_Profile_Reducer_12x55:</td>
<td> <input type="checkbox" name="Adaptor_Profile_Reducer_12x55" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">APRSpecs:</td>
<td> <input type="text" name="APRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">APRStock#:</td>
<td> <input type="text" name="APRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">APRPrice:</td>
<td> <input type="text" name="APRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">End_Profile-Stair_Nose_14x36:</td>
<td> <input type="checkbox" name="End_ProfileStair_Nose_14x36" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPSNSpecs:</td>
<td> <input type="text" name="EPSNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPSNStock#:</td>
<td> <input type="text" name="EPSNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPSNPrice:</td>
<td> <input type="text" name="EPSNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Expansion_Profile_Reducer_12x46:</td>
<td> <input type="checkbox" name="Expansion_Profile_Reducer_12x46" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPRSpecs:</td>
<td> <input type="text" name="EPRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPRStock#:</td>
<td> <input type="text" name="EPRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EPRPrice:</td>
<td> <input type="text" name="EPRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Incizo:</td>
<td> <input type="checkbox" name="Incizo" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ISpecs:</td>
<td> <input type="text" name="ISpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">IStock#:</td>
<td> <input type="text" name="IStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">IPrice:</td>
<td> <input type="text" name="IPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Profile-Stair_Nose_20x65:</td>
<td> <input type="checkbox" name="Stair_ProfileStair_Nose_20x65" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SPSNSpecs:</td>
<td> <input type="text" name="SPSNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SPSNStock#:</td>
<td> <input type="text" name="SPSNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SPSNPrice:</td>
<td> <input type="text" name="SPSNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QS_Sub_Profile_70:</td>
<td> <input type="checkbox" name="QS_Sub_Profile_70" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP70Specs:</td>
<td> <input type="text" name="SP70Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP70Stock#:</td>
<td> <input type="text" name="SP70Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP70Price:</td>
<td> <input type="text" name="SP70Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QS_Sub_Profile_80:</td>
<td> <input type="checkbox" name="QS_Sub_Profile_80" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP80Specs:</td>
<td> <input type="text" name="SP80Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP80Stock#:</td>
<td> <input type="text" name="SP80Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP80Price:</td>
<td> <input type="text" name="SP80Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QS_Sub_Profile_95:</td>
<td> <input type="checkbox" name="QS_Sub_Profile_95" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP95Specs:</td>
<td> <input type="text" name="SP95Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP95Stock#:</td>
<td> <input type="text" name="SP95Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SP95Price:</td>
<td> <input type="text" name="SP95Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Quadra_Skirting-Wall_Base:</td>
<td> <input type="checkbox" name="Quadra_SkirtingWall_Base" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QSWBSpecs:</td>
<td> <input type="text" name="QSWBSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QSWBStock#:</td>
<td> <input type="text" name="QSWBStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QSWBPrice:</td>
<td> <input type="text" name="QSWBPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Quarter_Round_Skirting:</td>
<td> <input type="checkbox" name="Quarter_Round_Skirting" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QRSSpecs:</td>
<td> <input type="text" name="QRSSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QRSStock#:</td>
<td> <input type="text" name="QRSStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">QRSPrice:</td>
<td> <input type="text" name="QRSPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Install_Kit:</td>
<td> <input type="checkbox" name="Install_Kit" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">IKSpecs:</td>
<td> <input type="text" name="IKSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">IKStock#:</td>
<td> <input type="text" name="IKStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">IKPrice:</td>
<td> <input type="text" name="IKPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Nose_Reducer:</td>
<td> <input type="checkbox" name="Stair_Nose_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNRSpecs:</td>
<td> <input type="text" name="SNRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNRStock#:</td>
<td> <input type="text" name="SNRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNRPrice:</td>
<td> <input type="text" name="SNRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Reducer_W_Clip:</td>
<td> <input type="checkbox" name="Reducer_W_Clip" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RWCSpecs:</td>
<td> <input type="text" name="RWCSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RWCStock#:</td>
<td> <input type="text" name="RWCStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">RWCPrice:</td>
<td> <input type="text" name="RWCPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">T-Molding_W_Clip:</td>
<td> <input type="checkbox" name="TMolding_W_Clip" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMCSpecs:</td>
<td> <input type="text" name="TMCSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMCStock#:</td>
<td> <input type="text" name="TMCStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TMCPrice:</td>
<td> <input type="text" name="TMCPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Nose_W_Clip:</td>
<td> <input type="checkbox" name="Stair_Nose_W_Clip" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNCSpecs:</td>
<td> <input type="text" name="SNCSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNCStock#:</td>
<td> <input type="text" name="SNCStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SNCPrice:</td>
<td> <input type="text" name="SNCPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">End_Cap:</td>
<td> <input type="checkbox" name="End_Cap" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ECSpecs:</td>
<td> <input type="text" name="ECSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ECStock#:</td>
<td> <input type="text" name="ECStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ECPrice:</td>
<td> <input type="text" name="ECPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Transition_Strip:</td>
<td> <input type="checkbox" name="Transition_Strip" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TSSpecs:</td>
<td> <input type="text" name="TSSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TSStock#:</td>
<td> <input type="text" name="TSStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TSPrice:</td>
<td> <input type="text" name="TSPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">T-Expansion:</td>
<td> <input type="checkbox" name="TExpansion" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TESpecs:</td>
<td> <input type="text" name="TESpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TEStock#:</td>
<td> <input type="text" name="TEStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TEPrice:</td>
<td> <input type="text" name="TEPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Acoustic_Molding:</td>
<td> <input type="checkbox" name="Acoustic_Molding" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">AMSpecs:</td>
<td> <input type="text" name="AMSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">AMStock#:</td>
<td> <input type="text" name="AMStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">AMPrice:</td>
<td> <input type="text" name="AMPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Base_Board:</td>
<td> <input type="checkbox" name="Base_Board" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BBSpecs:</td>
<td> <input type="text" name="BBSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BBStock#:</td>
<td> <input type="text" name="BBStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">BBPrice:</td>
<td> <input type="text" name="BBPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Overlap_Step_Nose:</td>
<td> <input type="checkbox" name="Overlap_Step_Nose" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSNSpecs:</td>
<td> <input type="text" name="OSNSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSNStock#:</td>
<td> <input type="text" name="OSNStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">OSNPrice:</td>
<td> <input type="text" name="OSNPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">One_Step_Stair_Tread:</td>
<td> <input type="checkbox" name="One_Step_Stair_Tread" value=1 >
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">1SSTSpecs:</td>
<td> <input type="text" name="SSTSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">1SSTStock#:</td>
<td> <input type="text" name="SSTStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">1SSTPrice:</td>
<td> <input type="text" name="SSTPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FausTrim_5_In_1:</td>
<td> <input type="checkbox" name="FausTrim_5_In_1" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">F5I1Specs:</td>
<td> <input type="text" name="F5I1Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">F5I1Stock#:</td>
<td> <input type="text" name="F5I1Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">F5I1Price:</td>
<td> <input type="text" name="F5I1Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">NONEAVAIL:</td>
<td> <input type="checkbox" name="NONEAVAIL" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Riser:</td>
<td> <input type="checkbox" name="Stair_Riser" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SRSpecs:</td>
<td> <input type="text" name="SRSpecs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SRStockNumber:</td>
<td> <input type="text" name="SRStockNumber" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SRPrice:</td>
<td> <input type="text" name="SRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Stair_Riser2:</td>
<td> <input type="checkbox" name="Stair_Riser2" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SR2Specs:</td>
<td> <input type="text" name="SR2Specs" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SR2Stock#:</td>
<td> <input type="text" name="SR2Stock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">SR2Price:</td>
<td> <input type="text" name="SR2Price" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Floating_Reducer:</td>
<td> <input type="checkbox" name="Floating_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FRStock#:</td>
<td> <input type="text" name="FRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FRPrice:</td>
<td> <input type="text" name="FRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Glue_Reducer:</td>
<td> <input type="checkbox" name="Glue_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">GRStock#:</td>
<td> <input type="text" name="GRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">GRPrice:</td>
<td> <input type="text" name="GRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Flush_Reducer:</td>
<td> <input type="checkbox" name="Flush_Reducer" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FluRStock#:</td>
<td> <input type="text" name="FluRStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FluRPrice:</td>
<td> <input type="text" name="FluRPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">St_Nose_Floating:</td>
<td> <input type="checkbox" name="St_Nose_Floating" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNFloStock#:</td>
<td> <input type="text" name="StNFloStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNFloPrice:</td>
<td> <input type="text" name="StNFloPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">St_Nose_Glue:</td>
<td> <input type="checkbox" name="St_Nose_Glue" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNGlStock#:</td>
<td> <input type="text" name="StNGlStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNGlPrice:</td>
<td> <input type="text" name="StNGlPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">St_Nose_Flush:</td>
<td> <input type="checkbox" name="St_Nose_Flush" value=1 > </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNFluStock#:</td>
<td> <input type="text" name="StNFluStock" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">StNFluPrice:</td>
<td> <input type="text" name="StNFluPrice" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td> <input type="submit" value="Update Record"> </td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form2">
<input type="hidden" name="MM_recordId" value="<%= coordinatingaccessories.Fields.Item("moldingid".Value %>">
</form>
<p> </p></td>
</tr>
<tr>
<td width="211" valign="top" background="drkgreen.png" bgcolor="#8B9A97">
<table height="1" border="0" cellpadding="1" cellspacing="1">
<% While ((Repeat1__numRows <> 0) AND (NOT mannav.EOF)) %>
<tr>
<td><p><font face="Verdana" size="3"><a href="admin_manufacturerstemplate.asp?manufacturerid=<%=(mannav.Fields.Item("manufacturerid".Value)%>"><%=(mannav.Fields.Item("manufacturername".Value)%></a></font></p>
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
mannav.MoveNext()
Wend
%>
</table><p><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><a href="admin_unfinished_floors.asp">Unfinished
Wood Flooring</a><br>
<a href="admin_manstatus.asp">Manage Man Status</a></font></p></td>
</tr>
<tr>
<td width="211" bgcolor="#CAB890" background="drkgreen.png" height="59">
<p align="center"><img src="authorizenetexample.jpg" width="140" height="50" border="0"></p>
</td>
<td width="502" height="59" valign="top" bgcolor="white">
<p> </p>
</td>
<td width="263" bgcolor="#CAB890" valign="middle" height="59" background="drkgreen.png">
<p align="center"><img src="img1.gif" width="140" height="50" border="0" alt="img1.gif"></p>
</td>
</tr>
<tr>
<td width="976" bgcolor="#CAB890" background="drkgreen.png" height="27" colspan="3">
<p align="center"><font face="Verdana" size="1"><b><a href="www.qualityfloorsdirect.com">Home</a> | <a href="contact.asp">Contact
Our Professionals</a> | <a href="weekly_specials.asp">Weekly Specials</a> | <a href="gallery.asp">Flooring
Gallery</a> | <a href="install_services.asp">Installation Services</a> | <a href="customer_service.asp" target="_new">Customer Service</a>
| <a href="customer_service.asp" target="_new">Product Care</a> | <a href="links.asp">Links</a> | <a href="customer_service.asp" target="_new">FAQ</a></b></font></p>
</td>
</tr>
</table>
<p align="center"> <font face="Verdana" size="1">C 2007 Sierra Flooring
| All Rights Reserved. Terms & Policies</font></p>
</body>
</html>
<%
mannav.Close()
Set mannav = Nothing
%>
<%
coordinatingaccessories.Close()
Set coordinatingaccessories = Nothing
%>