03. september 2003 - 01:43
#3
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../Connections/capitol.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 = ""
%>
<%
' *** Insert Record: set variables
If (CStr(Request("MM_insert")) = "form1") Then
MM_editConnection = MM_capitol_STRING
MM_editTable = "product"
MM_editRedirectUrl = "view_products.asp"
MM_fieldsStr = "brand|value|category|value|Sex|value|productname|value|productfacts|value|description|value|colour|value|XS|value|24|value|w5|value|m5|value|Onesize|value|S|value|26|value|w5½|value|m6|value|M|value|28|value|w6|value|m6½|value|L|value|30|value|w6½|value|m7|value|XL|value|32|value|w7|value|m7½|value|XXL|value|34|value|w7½|value|m8|value|36|value|w8|value|m8½|value|38|value|w8½|value|m9|value|w9|value|m9½|value|w9½|value|m10|value|w10|value|m10½|value|m11|value|m11½|value|m12|value|m12½|value|m13|value|price|value|Active|value|imagename|value"
MM_columnsStr = "Brand|',none,''|Category|',none,''|Sex|',none,''|ProductName|',none,''|ProductFacts|',none,''|ProductDescription|',none,''|Colour|',none,''|XS|none,'Y','N'|24|none,'Y','N'|w5|none,'Y','N'|m5|none,'Y','N'|Onesize|none,'Y','N'|S|none,'Y','N'|26|none,'Y','N'|w5½|none,'Y','N'|m6|none,'Y','N'|M|none,'Y','N'|28|none,'Y','N'|w6|none,'Y','N'|m6½|none,'Y','N'|L|none,'Y','N'|30|none,'Y','N'|w6½|none,'Y','N'|m7|none,'Y','N'|XL|none,'Y','N'|32|none,'Y','N'|w7|none,'Y','N'|m7½|none,'Y','N'|XXL|none,'Y','N'|34|none,'Y','N'|w7½|none,'Y','N'|m8|none,'Y','N'|36|none,'Y','N'|w8|none,'Y','N'|m8½|none,'Y','N'|38|none,'Y','N'|w8½|none,'Y','N'|m9|none,'Y','N'|w9|none,'Y','N'|m9½|none,'Y','N'|w9½|none,'Y','N'|m10|none,'Y','N'|w10|none,'Y','N'|m10½|none,'Y','N'|m11|none,'Y','N'|m11½|none,'Y','N'|m12|none,'Y','N'|m12½|none,'Y','N'|m13|none,'Y','N'|Price|none,none,NULL|Active|none,'Y','N'|ImageName|',none,''"
' 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
%>
<%
' *** Insert Record: construct a sql insert statement and execute it
Dim MM_tableValues
Dim MM_dbValues
If (CStr(Request("MM_insert")) <> "") Then
' create the sql insert statement
MM_tableValues = ""
MM_dbValues = ""
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_tableValues = MM_tableValues & ","
MM_dbValues = MM_dbValues & ","
End If
MM_tableValues = MM_tableValues & MM_columns(MM_i)
MM_dbValues = MM_dbValues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"
If (Not MM_abortEdit) Then
' execute the insert
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="/admin/login.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 brand
Dim brand_numRows
Set brand = Server.CreateObject("ADODB.Recordset")
brand.ActiveConnection = MM_capitol_STRING
brand.Source = "SELECT * FROM Brand ORDER BY Brand ASC"
brand.CursorType = 0
brand.CursorLocation = 2
brand.LockType = 1
brand.Open()
brand_numRows = 0
%>
<%
Dim category
Dim category_numRows
Set category = Server.CreateObject("ADODB.Recordset")
category.ActiveConnection = MM_capitol_STRING
category.Source = "SELECT * FROM Category ORDER BY Category ASC"
category.CursorType = 0
category.CursorLocation = 2
category.LockType = 1
category.Open()
category_numRows = 0
%>
<%
Dim update_product__MMColParam
update_product__MMColParam = "1"
If (Request.QueryString("IDproduct") <> "") Then
update_product__MMColParam = Request.QueryString("IDproduct")
End If
%>
<%
Dim update_product
Dim update_product_numRows
Set update_product = Server.CreateObject("ADODB.Recordset")
update_product.ActiveConnection = MM_capitol_STRING
update_product.Source = "SELECT * FROM product WHERE IDproduct = " + Replace(update_product__MMColParam, "'", "''") + ""
update_product.CursorType = 0
update_product.CursorLocation = 2
update_product.LockType = 1
update_product.Open()
update_product_numRows = 0
%>
<%
Dim sex
Dim sex_numRows
Set sex = Server.CreateObject("ADODB.Recordset")
sex.ActiveConnection = MM_capitol_STRING
sex.Source = "SELECT * FROM sex"
sex.CursorType = 0
sex.CursorLocation = 2
sex.LockType = 1
sex.Open()
sex_numRows = 0
%>
<html>
<head>
<title>CMS System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<link href="/admin/capitoladmin.css" rel="stylesheet" type="text/css">
<link href="/admin/capitoladmin.css" rel="stylesheet" type="text/css">
</head>
<body background="/images/cms/background.jpg" onLoad="MM_preloadImages('/images/cms/products_down.jpg')">
<table width="736" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">
<tr>
<td colspan="2"><table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="19%" align="center" valign="middle"><body>
<img src="/images/cms/adminlogo.jpg" width="123" height="12"> </td>
<td width="81%"><table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<body onLoad="MM_preloadImages('/images/cms/products_down.jpg','/images/cms/articles_down.jpg','/images/cms/information_down.jpg','/images/cms/images_down.jpg','/images/cms/orders_down.jpg')">
<table align="right" cellpadding="0" cellspacing="1">
<tr>
<td colspan="7"> <div align="right">
<p class="text"><a href="/admin/products/input_product.asp?MM_Logoutnow=1"><img src="/images/cms/logout.jpg" width="39" height="7" border="0"></a> <a href="mailto:fuzzy@fzy.dk"><img src="/images/cms/contact.jpg" width="43" height="7" border="0"></a></p>
</div></td>
</tr>
<tr>
<td><img src="/images/cms/products_down.jpg" alt="Products" name="products" width="85" height="28" border="0"></a></td>
<td><a href="/admin/articles/articles.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('articles','','/images/cms/articles_down.jpg',1)"><img src="/images/cms/articles_up.jpg" alt="Articles" name="articles" width="85" height="28" border="0"></a></td>
<td><a href="/admin/information/information.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('information','','/images/cms/information_down.jpg',1)"><img src="/images/cms/information_up.jpg" alt="Information" name="information" width="85" height="28" border="0"></a></td>
<td><a href="/admin/images/images.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('images','','/images/cms/images_down.jpg',1)"><img src="/images/cms/images_up.jpg" alt="Images" name="images" width="85" height="28" border="0"></a></td>
<td><a href="/admin/orders/orders.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('orders','','/images/cms/orders_down.jpg',1)"><img src="/images/cms/orders_up.jpg" alt="Orders" name="orders" width="85" height="28" border="0"></a></td>
<td colspan="2" valign="top"> <div align="right"><img src="/images/cms/topbar.jpg" width="162" height="24"></div></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td> </tr>
<tr>
<td colspan="2" bgcolor="#D9E1E6"> </td>
</tr>
<tr>
<td width="174" align="left" valign="top" nowrap>
<link href="/admin/capitoladmin.css" rel="stylesheet" type="text/css">
<!--#include virtual="/admin/include_files/product_left.asp" --> </td>
<td width="552" align="left" valign="top"><form ACTION="<%=MM_editAction%>" METHOD="POST" name="form1">
<table align="left" style="border-right: 1px solid #CCCCCC" width="70%" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="19" align="left" valign="top" class="contentTop"><img src="/images/cms/white.jpg" width="6" height="6"></td>
<td height="57" colspan="2" class="contentTop" style="border-bottom: 1px solid #CCCCCC">Input
Product</td>
<td rowspan="19" align="left" valign="top" class="contentTop"><img src="/images/cms/white.jpg" width="6" height="6"></td>
</tr>
<tr>
<td class="contentText"> </td>
<td>new</td>
</tr>
<tr>
<td width="150" class="contentText">Brand</td>
<td> <select name="brand" class="fields" id="select3">
<option value="">Choose</option>
<%
While (NOT brand.EOF)
%>
<option value="<%=(brand.Fields.Item("Brand").Value)%>"><%=(brand.Fields.Item("Brand").Value)%></option>
<%
brand.MoveNext()
Wend
If (brand.CursorType > 0) Then
brand.MoveFirst
Else
brand.Requery
End If
%>
</select></td>
</tr>
<tr>
<td width="150" class="contentText">Category</td>
<td><select name="category" class="fields" id="category">
<option value="">Choose</option>
<%
While (NOT category.EOF)
%>
<option value="<%=(category.Fields.Item("Category").Value)%>"><%=(category.Fields.Item("Category").Value)%></option>
<%
category.MoveNext()
Wend
If (category.CursorType > 0) Then
category.MoveFirst
Else
category.Requery
End If
%>
</select> </td>
</tr>
<tr>
<td class="contentText">Sex</td>
<td><select name="Sex" class="fields" id="Sex">
<option value="">Choose</option>
<%
While (NOT sex.EOF)
%>
<option value="<%=(sex.Fields.Item("Sex").Value)%>"><%=(sex.Fields.Item("Sex").Value)%></option>
<%
sex.MoveNext()
Wend
If (sex.CursorType > 0) Then
sex.MoveFirst
Else
sex.Requery
End If
%>
</select></td>
</tr>
<tr>
<td width="150" class="contentText">Product name</td>
<td><input name="productname" type="text" class="fields" id="productname"></td>
</tr>
<tr>
<td width="150" class="contentText">Product facts</td>
<td> <textarea name="productfacts" rows="2" class="multilineFields" id="productfacts"></textarea></td>
</tr>
<tr>
<td width="150" class="contentText">Description</td>
<td><textarea name="description" rows="4" class="multilineFields" id="description"></textarea></td>
</tr>
<tr>
<td width="150" class="contentText">Colour</td>
<td><input name="colour" type="text" class="fields" id="colour"></td>
</tr>
<tr>
<td width="150" class="contentText">Available Sizes</td>
<td> </td>
</tr>
<tr>
<td colspan="2" class="contentText"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td colspan="2">Misc.</td>
<td width="10" rowspan="17" style="border-left:1px solid #5F7383;"> </td>
<td colspan="2"><div align="left">Pants</div></td>
<td width="10" rowspan="17" style="border-left:1px solid #5F7383"> </td>
<td colspan="2"><div align="left">W Shoes</div></td>
<td width="10" rowspan="17" style="border-left:1px solid #5F7383"> </td>
<td colspan="2"><div align="left">M Shoes</div></td>
<td width="10" rowspan="17" style="border-left:1px solid #5F7383"> </td>
<td colspan="2"><div align="left">Onesize</div></td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td width="30">XS</td>
<td> <input name="XS" type="checkbox" id="XS" value="XS"></td>
<td width="30">24</td>
<td><input name="24" type="checkbox" id="24" value="24"></td>
<td width="30">5</td>
<td><input name="w5" type="checkbox" id="w5" value="5"></td>
<td width="30">5</td>
<td><input name="m5" type="checkbox" id="m5" value="5"></td>
<td width="30">One</td>
<td><input name="Onesize" type="checkbox" id="Onesize" value="Onesize"></td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td>S</td>
<td><input name="S" type="checkbox" id="S" value="S"></td>
<td>26</td>
<td><input name="26" type="checkbox" id="26" value="26"></td>
<td>5½</td>
<td><input name="w5½" type="checkbox" id="w5½" value="5½"></td>
<td>6</td>
<td><input name="m6" type="checkbox" id="m6" value="6"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td>M</td>
<td><input name="M" type="checkbox" id="M" value="M"></td>
<td>28</td>
<td><input name="28" type="checkbox" id="28" value="28"></td>
<td>6</td>
<td><input name="w6" type="checkbox" id="w6" value="6"></td>
<td>6½</td>
<td><input name="m6½" type="checkbox" id="m6½" value="6½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td>L</td>
<td><input name="L" type="checkbox" id="L" value="L"></td>
<td>30</td>
<td><input name="30" type="checkbox" id="30" value="30"></td>
<td>6½</td>
<td><input name="w6½" type="checkbox" id="w6½" value="6½"></td>
<td>7</td>
<td><input name="m7" type="checkbox" id="m7" value="7"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td>XL</td>
<td><input name="XL" type="checkbox" id="XL" value="XL"></td>
<td>32</td>
<td><input name="32" type="checkbox" id="32" value="32"></td>
<td>7</td>
<td><input name="w7" type="checkbox" id="w7" value="7"></td>
<td>7½</td>
<td><input name="m7½" type="checkbox" id="m7½" value="7½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td>XXL</td>
<td><input name="XXL" type="checkbox" id="XXL" value="XXL"></td>
<td>34</td>
<td><input name="34" type="checkbox" id="34" value="34"></td>
<td>7½</td>
<td><input name="w7½" type="checkbox" id="w7½" value="7½"></td>
<td>8</td>
<td><input name="m8" type="checkbox" id="m8" value="8"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td>36</td>
<td><input name="36" type="checkbox" id="36" value="36"></td>
<td>8</td>
<td><input name="w8" type="checkbox" id="w8" value="8"></td>
<td>8½</td>
<td><input name="m8½" type="checkbox" id="m8½" value="8½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td>38</td>
<td><input name="38" type="checkbox" id="38" value="38"></td>
<td>8½</td>
<td><input name="w8½" type="checkbox" id="w8½" value="8½"></td>
<td>9</td>
<td><input name="m9" type="checkbox" id="m9" value="9"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>9</td>
<td><input name="w9" type="checkbox" id="w9" value="9"></td>
<td>9½</td>
<td><input name="m9½" type="checkbox" id="m9½" value="9½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>9½</td>
<td><input name="w9½" type="checkbox" id="w9½" value="9½"></td>
<td>10</td>
<td><input name="m10" type="checkbox" id="m10" value="10"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>10</td>
<td><input name="w10" type="checkbox" id="w10" value="10"></td>
<td>10½</td>
<td><input name="m10½" type="checkbox" id="m10½" value="10½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>11</td>
<td><input name="m11" type="checkbox" id="m11" value="11"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>11½</td>
<td><input name="m11½" type="checkbox" id="m11½" value="11½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>12</td>
<td><input name="m12" type="checkbox" id="m12" value="12"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>12½</td>
<td><input name="m12½" type="checkbox" id="m12½" value="12½"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>13</td>
<td><input name="m13" type="checkbox" id="m13" value="13"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td class="contentText"> </td>
<td> </td>
</tr>
<tr>
<td width="150" class="contentText">Price</td>
<td><input name="price" type="text" class="fields" id="price"></td>
</tr>
<tr>
<td width="150" class="contentText">Active</td>
<td> <input name="Active" type="checkbox" id="Active" value="Y" checked></td>
</tr>
<tr>
<td width="150" class="contentText">Image name</td>
<td><input name="imagename" type="text" class="fields" id="imagename"></td>
</tr>
<tr>
<td width="150" class="contentText"> </td>
<td> </td>
</tr>
<tr>
<td width="150" class="contentText"> </td>
<td><input type="submit" name="Submit" value="Input" class="buttons">
</td>
</tr>
<tr>
<td width="150" class="contentText"> </td>
<td> </td>
</tr>
<tr>
<td width="150" class="contentText"> </td>
<td> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<span class="contentText"><br>
<br>
<br>
<br>
<br>
<br>
</span><br>
</td>
</tr>
<tr>
<td colspan="2"><div align="right">
<body>
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><div align="right"><img src="/images/cms/allrights.jpg" width="174" height="7"></div></td>
</tr>
</table>
</div></td>
<td width="2"> <div align="right"></div></td>
</tr></table>
</body>
</html>
<%
brand.Close()
Set brand = Nothing
%>
<%
category.Close()
Set category = Nothing
%>
<%
update_product.Close()
Set update_product = Nothing
%>
<%
sex.Close()
Set sex = Nothing
%>