PDA

Click to See Complete Forum and Search --> : listing contects of database

Blelisa
12-20-2006, 10:58 AM
Hello everyone,

I have an asp page that I want to list all the contents of my table in my database. I keep getting this error:
Microsoft VBScript runtime error '800a01a8'

Object required: ''

/magnefor/viewall1.asp, line 51

Here is my code for viewall1.asp I don't understand what my wrong syntax is. Do you?
<%
objRS.MoveFirst(this is line 61)
Do While Not objRS.EOF
%>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="1"><a href="details.asp?ID=<%= objRS("Tnum")%>"><%= objRS("Tnum") %></a></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("DateEntered")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("BugDescription")%></font></td>
<td><%=objRS("genac")%>,&nbsp;<%=objRS("bldc")%>,&nbsp;<%=objRS("bcpm")%>,&nbsp;<%=objRS("indu")%></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("SimulatorVersion")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Project")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Enteredby")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("FoundandReportedBy")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Priority")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Stat")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("CorrectedDate")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("CorrectedNotes")%></font></td>
<%
objRS.MoveNext
Loop%>
</tr>
</table>
<%
objRS.Close
set objRS = Nothing
connection.Close
set connection = Nothing
%>
<p>&nbsp;</p>
</div>
</div>
<div align="left"></div>
</blockquote></td>
</tr>
<tr bgcolor="#000066">
<td height="21" colspan="2"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">MagneForce
Software Systems, Inc</font><font color="#FFFFFF">.</font></div></td>
</tr>
</table>
</div>

Thank you in advance
russell
12-20-2006, 11:19 AM
can we see the code that creates objRS ? and the sql statement that is executed? also, what db?
Blelisa
12-20-2006, 11:24 AM
Here is the whole code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<div align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="915" height="280">
<param name="movie" value="testingshapetween.swf">
<param name="quality" value="high">
<embed src="testingshapetween.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="915" height="280"></embed></object>
</div>
<table width="914" border="0" align="center">
<tr>
<td width="896" height="497" colspan="2" valign="top"> <div align="center">
<p><font color="#FF0000" size="5" face="Arial, Helvetica, sans-serif">MagneForce
Bug Database</font></p>
</div>
<blockquote>
<div align="left">
<p><font color="#000000" size="4" face="Arial, Helvetica, sans-serif">To
view individual records, please click on the ticket number. </font>
</p>
<div align="left">
<table width="100%" border="1" bordercolor="#000033">
<tr valign="middle" bgcolor="#0000CC">
<td width="59"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Ticket
Number</strong></font></div></td>
<td width="58"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Date
Entered</strong></font></div></td>
<td width="83"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Description</strong></font></div></td>
<td><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Simulator
Affected</strong></font> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"></font></div></td>
<td width="79"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Simulator
Version</strong></font></div></td>
<td width="62"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Project</strong></font></div></td>
<td width="55"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Entered
by</strong></font></div></td>
<td width="47"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Found
By</strong></font></div></td>
<td width="50"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Priority</strong></font></div></td>
<td width="42"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Status</strong></font></div></td>
<td width="66"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Corrected
Date</strong></font></div></td>
<td width="139"> <div align="center"><font color="#FFFFFF" size="3" face="Times New Roman, Times, serif"><strong>Corrected
Notes</strong></font></div></td>
</tr>
<%
objRS.MoveFirst
Do While Not objRS.EOF
%>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="1"><a href="details.asp?ID=<%= objRS("Tnum")%>"><%= objRS("Tnum") %></a></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("DateEntered")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("BugDescription")%></font></td>
<td><%=objRS("genac")%>,&nbsp;<%=objRS("bldc")%>,&nbsp;<%=objRS("bcpm")%>,&nbsp;<%=objRS("indu")%></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("SimulatorVersion")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Project")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Enteredby")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("FoundandReportedBy")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Priority")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("Stat")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("CorrectedDate")%></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><%=objRS("CorrectedNotes")%></font></td>
<%
objRS.MoveNext
Loop%>
</tr>
</table>
<%
objRS.Close
set objRS = Nothing
connection.Close
set connection = Nothing
%>
<p>&nbsp;</p>
</div>
</div>
<div align="left"></div>
</blockquote></td>
</tr>
<tr bgcolor="#000066">
<td height="21" colspan="2"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">MagneForce
Software Systems, Inc</font><font color="#FFFFFF">.</font></div></td>
</tr>
</table>
</div>
</body>
</html>
</body>
</html>
russell
12-20-2006, 11:49 AM
nowhere in your code are u declaring or creating objRS, nor executing a query...