Hi Guys,

I'm having a problem with the following code:

<textarea name="MESSAGE" cols="50" rows="7" class="inputFieldIE" id="textarea"><%=(rsBody.Fields.Item("Forward_Mess age").Value)%>&nbsp;&nbsp;<%=(rsBody.Fields.Item(" URL_Dir").Value)%>/ad.asp?cat_id=<%=(rsCat.Fields.Item("CAT_ID").Valu e)%>&sub_id=<%=(rsSub.Fields.Item("SUB_ID").Value) %>&AD_ID=<%=(rsDetail.Fields.Item("AD_ID").Value)% ></textarea>

The first part of the code work until it hits: /ad.asp?........

The text on my web page is displayed as follows:

Hi there! I saw this article which might interest you. http://www.xyzz.com/ad.asp?cat_id= <font face="Arial" size=2>
<p>ADODB.Field</font> <font face="Arial" size=2>error '800a0bcd'</font>

I hoping that someone here can tell me what I need to change in the code to correct my test display problem.

Thanks,

rsCat.Fields.Item("CAT_ID").Valu e <--- if you put a space between the U and the E, that's your problem. Other than that, your issue is that your field name is invalid.

If you view source of the page in error you will see the rest of the error message as well.

Hi Gents,

Thanks for the reply. There is no space between the u and e. Don't know why it came out like that when I pasted it.

Chrishirst,

Sorry, I'm sure I understand view source of the page in error you will see the rest of the error message as well.

What I see on the website is:

Hi there! I saw this article which might interest you. http://www.xxyz.com/ad.asp?cat_id= <font face="Arial" size=2>
<p>ADODB.Field</font> <font face="Arial" size=2>error '800a0bcd'</font>
<p>
<font face="Arial" size=2>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.</font>
<p>
<font face="Arial" size=2>/forwardAd.asp</font><font face="Arial" size=2>, line 219</font>
<script language='javascript'>postamble();</script>

The Source (in View Source) is:

<tr align="left" valign="middle">
<td width="127" valign="top" class="title"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#333333">Message:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#333333">
<textarea name="MESSAGE" cols="50" rows="7" class="inputFieldIE" id="textarea">Hi there! I saw this article which might interest you.&nbsp;&nbsp;http://www.xxyz.com/ad.asp?cat_id= <font face="Arial" size=2>
<p>ADODB.Field</font> <font face="Arial" size=2>error '800a0bcd'</font>
<p>
<font face="Arial" size=2>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.</font>
<p>
<font face="Arial" size=2>/forwardAd.asp</font><font face="Arial" size=2>, line 219</font>
<script language='javascript'>postamble();</script>

I still don't know what to change to fix the problem.

And there is your error

You have either gone past the end of the recordset in a loop or there was no records returned by the query

Hirst is right. Likely the case is the latter...you queried and expected a result where there was none.

Although looking more closely at your code, it appears that you have multiple recordset objects, each containing a single field name. This likely isn't the case. Usually the case is that there is one object containing multiple field names, something like this:

SQL_Query = "Select Company, Contact, Email from Companies where Company_ID = 7"
RS.Open SQL_Query
if RS.RecordCount > 0 then ' this is done to make sure that there is a recordset with information in it.
    Company = RS.Fields ("Company").Value ' alternatively, just RS ("Company") will work and seems to perform much faster...I haven't seen anything one way or the other that establishes this or disproves it, though.
     Contact = RS.Fields ("Contact").Value
     Email = RS.Fields ("Email").value
end if
RS.Close

As you can see, I used one recordset and retrieved values for three fields from it.

I can't recall off the top of my head if you'll get the same error if you have a misnamed recordset (if I recall correctly, you'll get an Object Required error...Hirst can probably verify), but it certainly isn't helping. The more objects you have open at once, the more strain you put on your server and the worse your script will perform as more and more people access it.