Unsrecified Error 1

dashusa · Jul 12, 2006

Hello i am making a page that displays data from a database .
I am using ASP and JScript
i am getting a wierd error because sometimes i can display the data and when i hit 'refresh' it brings up the error page and says that it is an unspecified error....
Please help me resolve this issue
Thank you
D

Miked811 · Jul 12, 2006

hi, can you please post the code...

dashusa · Jul 12, 2006

<%@ LANGUAGE="JScript"%>

<HTML>
<HEAD>
<TITLE>Admin View</TITLE>

</HEAD>
<%
var conn = Server.CreateObject("ADODB.Connection");
var recordSet = Server.CreateObject("ADODB.RecordSet");
conn.Open("DSN=excuse");
recordSet.Open("select * from Details",conn,adOpenKeyset,adLockOptimistic);
%>
<BODY>
<%
while(!recordSet.EOF)
{
%><table>
<tr>
<td><%=recordSet("FirstName")%></td>
<td><%=recordSet("LastName")%></td>
<td><%=recordSet("PhoneNumber")%></td>
<td><%=recordSet("Email")%></td>
<td><%=recordSet("Country")%></td>
<td><%=recordSet("City")%></td>
<td><%=recordSet("State")%></td>
<td><%=recordSet("Zip")%></td>
</tr>
<%
recordSet.MoveNext();
}%>
</script>
</table>
</BODY>
</HTML>

PHV · Jul 12, 2006

Close the recordset and the connection after the loop.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

dashusa · Jul 12, 2006

Brilliant!!
Stupid errors always get me
Thanks

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Unsrecified Error 1

dashusa

Programmer

Miked811

Programmer

dashusa

Programmer

PHV

MIS

dashusa

Programmer

Similar threads

Part and Inventory Search

Sponsor