Hello,
I have a table that has a field set that is a look-up to another table.
The problem is i want to display the data in a table but its only displayiny the value of the look up table and not the name .
How do I display the name?
Below is the code
I have a table that has a field set that is a look-up to another table.
The problem is i want to display the data in a table but its only displayiny the value of the look up table and not the name .
How do I display the name?
Below is the code
Code:
<html>
<head>
<title>Documents that have Errors</title>
<script language="javascript">
<!-- Hide Script from old browsers
function goTo(newLoc)
{
var newPage = newLoc.options[newLoc.selectedIndex].value;
if(newPage != "")
{
window.location.href = newPage;
}
}
// End Hiding -->
</script>
<%@ language="JScript"%>
<!-- Hide from older Browsers
<%
var conn = Server.CreateObject("ADODB.Connection");
var recordSet1 = Server.CreateObject("ADODB.RecordSet");
conn.Open("DSN=POnum");
recordSet1.Open("select * from Images where Status = 3",conn,1,3);
%>
// End Hiding -->
</head>
<body>
<img src="Banner.jpg"><br>
<form name="Choice">
<select name="status" onChange="goTo(this)">
<option value="" selected="selected">Please Choose A Status</option>
<option value="unread.asp">Unread</option>
<option value="read.asp">Read</option>
<option value="error.asp">Error</option>
<option value="rescan.asp">Rescan</option>
</select>
</form>
<h1>ERROR</h1>
<table border="1" width="100%">
<tr>
<th>ID</th>
<th>Image Source </th>
<th>P O Number</th>
<th>Status</th>
<th>Document Type </th>
<th>Job Name</th>
<th>Company</th>
<th>Flagged ?</th>
<th>Reason</th>
</tr>
<%
while(!recordSet1.EOF)
{
Response.Write("<tr>")
Response.Write("<td>"+ recordSet1("ID") + "</td>");
Response.Write("<td>"+ recordSet1("ImgSrc") + "</td>");
Response.Write("<td>"+ recordSet1("PONumber") + "</td>");
Response.Write("<td>"+ recordSet1("Status") + "</td>");
Response.Write("<td>"+ recordSet1("DocType") + "</td>");
Response.Write("<td>"+ recordSet1("JobName") + "</td>");
Response.Write("<td>"+ recordSet1("Company") + "</td>");
Response.Write("<td>"+ recordSet1("Flagged") + "</td>");
Response.Write("<td>"+ recordSet1("Reason") + "</td>");
Response.Write("</tr>")
recordSet1.MoveNext();
}
%>
</table>
</body>
</html>