Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    73

    Exclamation Unanswered: How do you check for non existant records?

    Here is some code that I use to check for null values in a record and display a friendly note, but I havent figured out how to modify the code to accomadate if there is no record at all I know its in the If rs("RMA_ID") = ????. Can anyone help me out on this please?

    Begin Code
    -------------------------------------------------
    <%
    If rs("RMA_ID") = Null Then
    Response.Write "No tracking information is available"
    Else
    Response.Write "<td><a href=""http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&sort_by=status &tracknums_displayed=5&TypeOfInquiryNumber=T&loc=e n_US&InquiryNumber1=" & rs("ShipmentID") & "&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=& InquiryNumber5=&AgreeToTermsAndConditions=yes&trac k.x=32&track.y=6"">Track</a>&nbsp;" & rs("ShipmentID") & "</td>"
    End If
    %>
    -------------------------------------------------
    Last edited by X-Centric; 06-27-04 at 04:25.

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Code:
    If rs.BOF AND rs.EOF Then 'BOF = Beginning of File, EOF = End of File
      Response.Write "No tracking information is available."
    Else
      ...
    End If
    That which does not kill me postpones the inevitable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •