473,396 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

problem with hyperlinks in asp

Hi,

I am facing problem while retrieving records in asp. The first time i load my page it works fine and displays the records but when i click on a link the page to refresh it, it gives the following error:

--------------------------------------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/htdocs/admin/PropertyListing.asp, line 178


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

Page:
GET /htdocs/admin/PropertyListing.asp

Time:
Wednesday, May 30, 2007, 12:27:42 PM


More information:
-------------------------------------------------------------------------------------------------------------

The asp code that i am using is as follows:

sqlStr = "EXECUTE GETDATA '" & StartValue & "','PROPERTY_ALPHAB','" & SqlStr1 & "','" & EndValue & "'"

Set rsData = objConn.Execute(sqlStr)

Do While NOT rsData.EOF
--- Some code here
Loop
--------------------------------------------------------------------------------------------------------------
Can any one help me out in this please.



Regards
Aman
May 30 '07 #1
1 1014
shweta123
692 Expert 512MB
Hi,

Can you please check the state of the Recordset before writing the Loop
e.g.
If rs.state =1 then
Do While NOT rsData.EOF
--- Some code here
Loop
End if
May 31 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Arpan | last post by:
I am working on Windows 2000 Professional. Due to some reasons, I had to re-install it. There is one particular ASP application named Track. The problem is I am able to visit only some of the pages...
1
by: Brandon | last post by:
A newbie question for you all: Suppose you have a webpage with two frames: a main frame, and a second frame. You have several hyperlinks to other websites in the second frame. What you want is...
6
by: Colleyville Alan | last post by:
I have an application that has an Access table that stores the locations of slides in a Powerpoint file. This used to work fine when there were about 4 files and 200 slides. The database would...
0
by: Tim | last post by:
Access 97: I have a table with a hyperlink field that I display on a form. I can click on the form field and the hyperlink activates correctly. However, if I try to activate the hyperlink using VB...
3
by: JV | last post by:
I have an ASP.NET web page where IE keyboard navigation does not appear to work as it should. Normally you can tab through hyperlinks on a web page, and press <ENTER> to activate the current...
4
by: Seefor | last post by:
Hi, I want my text hyperlinks to have a dotted border underneath, so I did this which works fine: a, a:link, a:visited, a:hover, a:active { color: #000; text-decoration: none;
1
by: Robin | last post by:
Hello! I'm having trouble with links and hyperlinks in MS Access 2003 - any help would be great! Question 1! The "insert hyperlink" icon opens a browser window, allows the user to browse...
1
by: rcoco | last post by:
Hi all, I have this big problem with hyperlinks I would appriciate any help please. My web site has two datagrids on the same page. And one has a list of names of the users which are in form of...
1
by: mforema | last post by:
Hi Everybody, I have an Access table with a field filled with outdated hyperlinks. I also have an excel spreadsheet that is the master list for these hyperlinks. The spreadsheet will be updated...
12
by: Frustratee | last post by:
Sorry guys, this is killing me. I have been fighting this issue for several weeks, to no avail. I am exporting the results of a query to an excel sheet, with one of the columns being from a field...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.