Help needed

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Help needed

Logged in as: Guest

arrSession:exec spGetSession 2,2,538

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Help needed
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Help needed - 12/19/2001 8:33:32 PM

kbains

Posts: 1
Score: 0
Joined: 9/12/2001
From:
Status: offline

<%@LANGUAGE="VBSCRIPT"%>
<%
Dim oRS, oConn, strSQL, Image

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data source=" & Server.Mappath("_private/fpdb/addProfile.mdb") & ";"

oConn.Open
strSQL = "SELECT * FROM Results WHERE nickname = '" & nickname & "';"
Set oRS = CreateObject("ADODB.Recordset")

oRS.MaxRecords = 1

oRS.Open strSQL, oConn

%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Hotmatrimonials - image</title>

</head>
<body topmargin="0" leftmargin="0">

<img src="images/<% =oRS("Image")%>" >
<%
' No longer need the connection. Close it
oRS.Close
Set oRS = Nothing
oConn.Close
Set oConn = Nothing

%>

</body>

</html>

I am getting below error even in the presence of record in the database.

Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.