steveg
Posts: 278
Joined: 10/20/2004
Status: offline
 |
Linking to Correct record to edit - 7/18/2007 10:20:49
I have a search page which has a link for editing against each record. When I hover over the link for a particular record, it shows the relevant record id, however, when you choose the link it takes you to the first record in the file and yet when I select the edit link for record 2 the URL shows as:
http://www.teaching-uk.com/vacancy/edit_record.asp?ID=2
which would appear to be the right record?
The search page is as follows:
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Display all Vacancies View all current vacancies and choose a record to
edit if required</title>
</head>
<body>
<p><b><font color="#000080" face="Verdana" size="5">Display all Vacancies<br>
</font></b><font face="Verdana" size="2">View all current vacancies and choose a
record to edit if required</font></p>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,JobTitle,Location,JobDescription,Active,Notes,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,203,202,203,202,202,202,135" s-dataconnection="add_a_vacancy" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="ID,JobTitle,Location,JobDescription,Active,Notes,Timestamp" s-criteria s-order="[Timestamp] + [JobTitle] +" s-sql="SELECT * FROM Results ORDER BY Timestamp ASC,JobTitle ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<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="SELECT * FROM Results ORDER BY Timestamp ASC,JobTitle ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="add_a_vacancy"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="58748" --><table BORDER="1">
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>ID</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="62813" --></font></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Job Title</b></font></td>
<td width="496"><b><font face="Verdana" size="2" color="#000080">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="JobTitle" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>JobTitle<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"JobTitle")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16244" --></font></b></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Location</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="Location" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Location<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Location")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16691" --></font></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Job
Description</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="JobDescription" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>JobDescription<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"JobDescription")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="43741" --></font></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Date
Added</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Timestamp<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20579" --></font></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Active</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="Active" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Active<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Active")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13739" --></font></td>
</tr>
<tr>
<td width="114" bgcolor="#66CCFF"><font face="Verdana" size="2"><b>Notes</b></font></td>
<td width="496"><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,JobTitle,Location,JobDescription,Remote_computer_name,User_name,Browser_type,Timestamp,Active,Notes" s-column="Notes" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Notes<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Notes")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9199" --></font></td>
</tr>
<tr>
<td width="238" bgcolor="#FFFFFF">
<p align="center"><b><font face="Tahoma" size="2">
<a href="edit_record.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">Edit Record</a></font></b></td>
<td width="372" bgcolor="#FFFFFF">
<p align="center"><b><font face="Tahoma" size="2">
<a target="_top" href="index_vacancy_management_menu.htm">Back to Vacancy Main
Menu</a></font></b></td>
</tr>
</table>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p> </p>
</body>
</html>
and the edit page is as follows:
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 2057 %>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Edit Record Make Changes to your vacancy Remember you need to change the
date if you would like the item to appear at the top again</title>
</head>
<body>
<p><img border="0" src="../images/teaching_jobs_uk_title.jpg"></p>
<p><b><font face="Verdana" size="5" color="#000080">Edit Record<br>
</font></b><font face="Verdana" size="2">Make Changes to your vacancy<br>
Remember you need to change the date if you would like the item to appear at the
top again</font></p>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,JobTitle,Location,JobDescription,Active,Notes,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,203,202,203,202,202,202,135" s-dataconnection="add_a_vacancy" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="7" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="ID,JobTitle,Location,JobDescription,Active,Notes,Timestamp" s-criteria s-order s-sql="SELECT * FROM Results" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="1" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan b-WasTableFormat="FALSE" --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<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="SELECT * FROM Results"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="add_a_vacancy"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="31870" --><form METHOD="POST" action="post_record.asp">
<p>
<!--webbot bot="PurpleText" preview="Set this form's properties so it submits user input to the appropriate page." --></p>
<table BORDER="0">
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>Job
Title</b></font></td>
<td width="515">
<font face="Verdana">
<input TYPE="TEXT" NAME="JobTitle" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"JobTitle")%>"></font></td>
</tr>
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>
Location</b></font></td>
<td width="515">
<font face="Verdana">
<input TYPE="TEXT" NAME="Location" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Location")%>"></font></td>
</tr>
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>Job
Description</b></font></td>
<td width="515">
<font face="Verdana">
<textarea rows="4" name="JobDescription" cols="60" style="font-family: Verdana; font-size: 10pt"><%=FP_FieldHTML(fp_rs,"JobDescription")%></textarea></font></td>
</tr>
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>
Timestamp</b></font></td>
<td width="515">
<font face="Verdana">
<input NAME="Timestamp" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Timestamp")%>"></font></td>
</tr>
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>Active</b></font></td>
<td width="515">
<p>
<select size="1" name="Active">
<option value="Active" <%If FP_FieldHTML(fp_rs,"Active")="Active" Then Response.write(" selected") End If%>>
Active</option>
<option value="Inactive" <%If FP_FieldHTML(fp_rs,"Active")="Inactive" Then Response.write(" selected") End If%>>
Inactive</option>
</select></td>
</tr>
<tr>
<td bgcolor="#66CCFF" width="179"><font face="Verdana" size="2"><b>Notes</b></font></td>
<td width="515">
<font face="Verdana">
<input TYPE="TEXT" NAME="Notes" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Notes")%>"></font></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="submit" NAME="fp_submit" value="Update"><input TYPE="Reset" NAME="fp_reset"></td>
</tr>
</table>
<input type="hidden" name="ID" value="<%=Request("ID")%>">
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p align="center">
<b><font face="Tahoma" size="2">
<a target="_top" href="index_vacancy_management_menu.htm">Back to Vacancy Main Menu</a></font></b></p>
</body>
</html>
Any thoughts?
Steve
|
Printable Version 
k¥ 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread