about a BOF and EOF

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AAKK
    New Member
    • Feb 2010
    • 7

    about a BOF and EOF

    Hi below message which
    I send from aspmail out
    and when I click it from my email to below page
    it show as below

    Anyone could help?

    ADODB.Field error '800a0bcd'

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

    /e_card/your_card.asp, line 384

    below is code
    <td width="229" rowspan="2" bgcolor="#FF000 0"><p><img src="<%=(rsAllC ards.Fields.Ite m("File_Path"). Value)%>" width="233" /></p>


    /code
  • Soniad
    New Member
    • Jan 2009
    • 66

    #2
    Hi,

    Try using conditional statement
    Code:
    <%
    If Not rsAllCards.EOF Then
      While Not rsAllCards.EOF 
    %>
    <tr>
    <td width="229" rowspan="2" bgcolor="#FF0000"><p><img src="<%=rsAllCards.Fields("File_Path")%>" width="233" /></p>
    <tr>
    <%
       rsAllCards.MoveNext
       Wend
    Else 
    %>
    <tr>
    <td width="229" rowspan="2" bgcolor="#FF0000"><p>No Images Found..</p>
    <tr>
    <%End If%>

    Comment

    • GazMathias
      Recognized Expert New Member
      • Oct 2008
      • 228

      #3
      If I understand the problem correctly, a page of yours generates an email with a link to another of your pages (containing querystring information?), and when you click that link you receive an error on the page linked to?

      If that is the case, then you should be focusing on the page that generates the email and verify that it is emailing the correct information, or your underlying logic behind what you are trying to achieve.

      If your emails can contain links that would by design result in no data being returned by your linked page, then you should handle that scenario using Soniad's suggestion.

      Gaz.

      Comment

      Working...