R
Ray Medina
Hello People...
I have a table links to a delete_form_copy.asp and this form runs the ASP
from delete_copy.asp.
This is my code for the delete_copy.asp:
---------------
<% @language="vbscript" %>
<!--#include virtual="./_private/logon.inc"-->
<html>
<head>
<title>Delete Staff</title>
</head>
<body>
<!--webbot bot="Include" U-Include="../Include/Menu/updatelink.htm"
TAG="BODY" --><p> </p>
<table width="100%" border="1">
<thead>
</thead>
<tbody>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="DELETE FROM Staff1 WHERE id =ID"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">Your record has
been deleted!</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
++++++
My problem is as follows, This fp_sQry function is deleting all of the
records in the table. It is driving me nuts...
Also, if I pick a different field where there are duplicates, such as,
(Medina, Ray), it deletes all instances of the EmployeeName.
What would be the best way to delete only one record out of this database.
Please help
I have a table links to a delete_form_copy.asp and this form runs the ASP
from delete_copy.asp.
This is my code for the delete_copy.asp:
---------------
<% @language="vbscript" %>
<!--#include virtual="./_private/logon.inc"-->
<html>
<head>
<title>Delete Staff</title>
</head>
<body>
<!--webbot bot="Include" U-Include="../Include/Menu/updatelink.htm"
TAG="BODY" --><p> </p>
<table width="100%" border="1">
<thead>
</thead>
<tbody>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="DELETE FROM Staff1 WHERE id =ID"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">Your record has
been deleted!</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
++++++
My problem is as follows, This fp_sQry function is deleting all of the
records in the table. It is driving me nuts...
Also, if I pick a different field where there are duplicates, such as,
(Medina, Ray), it deletes all instances of the EmployeeName.
What would be the best way to delete only one record out of this database.
Please help