|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/thomasjolly1/admin/ |
Upload File : |
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/dsPets.asp" -->
<%
set rsProductsEditDelete = Server.CreateObject("ADODB.Recordset")
rsProductsEditDelete.ActiveConnection = MM_dsPets_STRING
rsProductsEditDelete.Source = "SELECT tblProduct.Product_ID, tblProduct.* FROM tblProduct WHERE (((tblProduct.Product_ID)=" & Request.QueryString("Product_ID") & "));"
rsProductsEditDelete.CursorType = 0
rsProductsEditDelete.CursorLocation = 2
rsProductsEditDelete.LockType = 3
rsProductsEditDelete.Open()
rsProductsEditDelete_numRows = 0
'We only want to display the selected record, rather than all of them.
If Request.QueryString("Product_ID") <> "" Then
RecordToEdit = Request.QueryString("Product_ID")
End If
If Request.Form("btnUpdate") = "Update" Then
rsProductsEditDelete.Fields("Productline_ID") = Request.Form("txtProductline_ID")
rsProductsEditDelete.Fields("Product_Name") = Request.Form("txtName")
rsProductsEditDelete.Fields("Price") = Request.Form("txtPrice")
rsProductsEditDelete.Fields("Checkout_Number") = Request.Form("txtCheckout_Number")
rsProductsEditDelete.Fields("Product_Description") = Request.Form("txtProduct_Description")
rsProductsEditDelete.Fields("Thumbnail") = Request.Form("txtThumbnail")
rsProductsEditDelete.Fields("Photo") = Request.Form("txtPhoto")
rsProductsEditDelete.Update
Updated = "True"
End If
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Jolly Antiques</TITLE>
<link rel="stylesheet" href="http://a451.g.akamai.net/7/451/1713/0045/www.potterybarn.com/pbecimgs/20011112-001/html/css/css.htm" type="text/css">
<link href="../css/style.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY BGCOLOR="FFFFFF" TOPMARGIN="0" LEFTMARGIN="0" MARGINHEIGHT="0" MARGINWIDTH="0" LINK="666666" ALINK="666666" VLINK="666666">
<!-- begin Top Nav -->
<!-- end Top Nav -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#999966"><img src="../images/jolly_logo.gif" width="352" height="87"></td>
<td bgcolor="#999966"><div align="right">
<table width="130" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><img src="../images/spacer.gif" width="10" height="2"></td>
</tr>
<tr>
<td><a href="add_product.asp">add new products</a> </td>
</tr>
<tr>
<td><a href="view.asp">modify products</a> </td>
</tr>
<tr>
<td><a href="view.asp">delete products </a></td>
</tr>
<tr>
<td><a href="view.asp">view list of products </a></td>
</tr>
<tr>
<td><img src="../images/spacer.gif" width="10" height="2"></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="2" bgcolor="#666633"><img src="images/spacer.gif" width="1" height="7"></td>
</tr>
<tr>
<td colspan="2" bgcolor="#999966"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td colspan="2" bgcolor="#666633"><img src="images/spacer.gif" width="1" height="3"></td>
</tr>
<tr>
<td colspan="2" bgcolor="#cccc99"><img src="images/spacer.gif" width="1" height="22"></td>
</tr>
</table>
<br>
<TABLE WIDTH="770" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD WIDTH="770" COLSPAN="3" height="40">
<form name="formUpdate" method="post" action="">
<div align="center" class="redBold">
<% If Updated = "True" Then %>
<b><%= rsProductsEditDelete.Fields("Product_Name") %></b> has been updated.
<a href="view.asp"><b>Click here</b></a> to go back to Edit more
records.</div>
<P>
<% End If %>
<table border="0" cellpadding="0" cellspacing="0" width="750">
<tr>
<td width="187" valign="top">
<div align="right">Productline ID:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtProductline_ID" size="40" value="<%= rsProductsEditDelete.Fields("Productline_ID") %>">
</td>
</tr>
<tr>
<td width="187" valign="top">
<div align="right">Product Name:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtName" size="40" value="<%= rsProductsEditDelete.Fields("Product_Name") %>">
</td>
</tr>
<tr>
<!-- <td width="187" valign="top">
<div align="right">Price:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtPrice" size="40" value="<%= rsProductsEditDelete.Fields("Price") %>">
</td> -->
</tr>
<tr>
<!-- <td width="187" valign="top">
<div align="right">Checkout Number:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtCheckout_Number" size="40" value="<%= rsProductsEditDelete.Fields("Checkout_Number") %>">
</td> -->
</tr>
<tr>
<td width="187" valign="top">
<div align="right">Product Description:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtProduct_Description" size="100" value="<%= rsProductsEditDelete.Fields("Product_Description") %>">
</td>
</tr>
<tr>
<td width="187" valign="top">
<div align="right">Thumbnail:</div>
</td>
<td width="563" valign="top">
<input type="text" name="txtThumbnail" size="40" value="<%= rsProductsEditDelete.Fields("Thumbnail") %>">
</td>
</tr>
<tr>
<td width="187">
<div align="right">Photo:</div>
</td>
<td width="563">
<input type="text" name="txtPhoto" size="40" value="<%= rsProductsEditDelete.Fields("Photo") %>">
</td>
</tr>
<tr>
<td width="187"> </td>
<td width="563">
<input type="submit" name="btnUpdate" value="Update">
</td>
</tr>
</table>
</form>
</table>
<TR>
<TD HEIGHT="34" COLSPAN="3"><IMG SRC="../images/spacer.gif" WIDTH="1" HEIGHT="34" ALT="" BORDER="0"></TD>
</TR>
<TR>
<TD WIDTH="20" NOWRAP><IMG SRC="../images/spacer.gif" WIDTH="1" HEIGHT="1" ALT="" BORDER="0"></TD>
<TD BGCOLOR="51000"><IMG SRC="../images/spacer.gif" WIDTH="730" HEIGHT="2" ALT="" BORDER="0"></TD>
<TD WIDTH="20" NOWRAP><IMG SRC="../images/spacer.gif" WIDTH="1" HEIGHT="1" ALT="" BORDER="0"></TD>
</TR>
<TR>
<TD COLSPAN="3"><IMG SRC="../images/spacer.gif" WIDTH="770" HEIGHT="2" ALT="" BORDER="0"></TD>
</TR>
</BODY>
</HTML>
<%
rsProductsEditDelete.Close()
%>