Cannot retrive value - ASP / Active Server Pages

114 New Member

Dear Friends,

I have create a form in which user can update his/her records. The data can retrieved from the code which i have put in dropdown menu. Now I want to display all the records as per the dropdown menu changed.

I have retrieved proposalcode from the table in a dropdown menu and from that dropdown menu I am selecting records from the same table.
I have tried it but I don't know why I am getting error.

I am getting the following error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/prog_report_qtr ly.asp, line 20

Here is the code........... ......

[HTML]

<%
propcode_list = request.form("p ropcode_list")

DIM mySQL_code,mySQ L_code1
mySQL_code = "SELECT propcode FROM register_confir med"
mySQL_code1 = "SELECT * FROM register_confir med where propcode = '"& propcode_list &"'"

DIM objRS, objRS2
Set objRS = Server.CreateOb ject("ADODB.Rec ordset")
Set objRS2 = Server.CreateOb ject("ADODB.Rec ordset")
objRS.Open mySQL_code1, con
objRS2.Open mySQL_code, con

if objRS2.recordco unt = 0 then
response.write "No records found"
else
propcode2 = objRS("propcode ")
proptitle2=objR S("proptitle" )
end if

%>

<html>
<head>
<script language="JavaS cript">
function gone()
{
location=docume nt.frm.propcode .options[document.frm.pr opcode.selected Index].value
}

</script>
</head>

<form name="frm" action="codevie w.asp" method="post">
<select name="propcode_ list">

<%
if objRS2.recordco unt = 0 then
%>

<option value="empty">N o records found</option>

<%
else

On Error Resume Next
objRS2.MoveFirs t
do while Not objRS2.eof
propcode1= objRS2("propcod e") %>

<option <% if propcode_list= propcode1 then %> selected<% end if %> value="<%= propcode1 %>"><%= propcode1 %></option>

<%
objRS2.MoveNext
loop
end if
%>

</select>

<input type="submit" value="Submit">
</form>

<%

response.write (propcode2)
response.write "<BR>"
response.write (proptitle2)

%>[/HTML]

Please help me out..........I really need it on urgent basis.....

Thanks
Deepak

May 4 '07 #1

Subscribe Reply

1766

Arnold Schuur

New Member

objRS is emptry. You should check objRS in stead of objRS2

Expand|Select|Wrap|Line Numbers

 
// if objRS2.recordcount = 0

if objRS.recordcount = 0 then  

response.write "No records found"

else

propcode2 = objRS("propcode")

proptitle2=objRS("proptitle")

end if

May 6 '07 #2

Similar topics

2753

can not retrive @@identity value

by: Allan | last post by:

I use select @@identity to return @@identity from my store procedure, but I could not retrive it from my Visual basic code, like variable= oRS.fields.item(0).value, it always says item can not be found....

Microsoft SQL Server

1703

how to retrive Current ApplicationId

by: TdarTdar | last post by:

Hello, what is the code to get the running applications "ApplicationId" Thanks Tdar

ASP.NET

2131

Is possible retrive index of a table in a dataset?

by: Gian Paolo | last post by:

Hi all on .net 2.0 i have a dataset and a table with some rows. Is there a way to retrive the current row index ? So i can retrive other value of that column... something like dataset.table.columnname.value regards paolo

C# / C Sharp

1277

how to retrive data in between the tags of a xml file using c programing language

by: avishekb | last post by:

can anyone suggest me how to retrive data from a xml file using c/c++. for example: <schema> <applt to>portno</applyto> <type>int</type> <value>8080</value> </schema> i want to retrive the value 8080 from the file and assign it to portno,so that when i am using portno in my program it will be replaced by 8080.

C / C++

1663

retrive stored image from the MSAccess

by: nehashri | last post by:

hi, I need one help regarding Asp with MsAccess database. Problem. ======== i want to retrive stored image from the MSAccess database using asp.

ASP / Active Server Pages

1910

how can retrive the input text

by: idsanjeev | last post by:

hello how can retrive the input text after submit button pressed and report a error message. i wants to post topic and if any error message is occured then retrive the inputed text but it forget its <%@ Language=VBScript%> <%Option Explicit If Request.Cookies("userid") = "" Then Response.Redirect "login.asp" Else Dim R, page,vopenflg Dim vlaunchby,i,vcount

ASP / Active Server Pages

1679

retrive value in textarea

by: idsanjeev | last post by:

hello i wants to retrive data in textarea like input text but in textarea value is not work so what should be use to retrive textarea value after any error <input type="text" name="name" value="<%=name%>"> [/code>

HTML / CSS

1777

Retrive the value from query string

by: arial | last post by:

Hi all, I need some help on retrive the value from query string. I have two web forms. One has the datagridview which displays the data from database. On one of the column I made a hyperlink to go to next page like, qi.aspx?qi_track={0} and now I need to open a detail of this qi_track on second page. how can I extract the value of qitrack from the url.

.NET Framework

1889

how to retrive value of textbox assined in page UNLOADevent in javascript....

by: abirami elango | last post by:

Hi, i have created a web application in vb.net. i have assigned a value to the textbox during page UNLOAD event as below.. ......... Protected Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload txtPopConfirm.Text = intCountAnswer1 End Sub

C# / C Sharp

9718

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10613

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10107

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9186

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7649

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5544

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4327

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3846

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General