Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Question 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"
    Response.Write "<td><a href="" &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

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    How about:

    If rs.EOF Then...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    May 2004


    Wow, the answer was so easy i overlooked it! Thank you very much for flippin the light switch.

Posting Permissions

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