How do you check for non existant records?

X-Centric · #1 (**permalink**) 06-27-04, 03:22

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> " & rs("ShipmentID") & "</td>"
End If
%>
-------------------------------------------------

Seppuku · #2 (**permalink**) 06-28-04, 02:52

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

Internet Services

Web Development

Digital Marketing

Consumer Tech