I am using SQL Server 2K and trying to retrieve a record using ASP to be displayed in my HTML page - but I am not able to dsiplay records. No error message too.
Here is the code snippet
Call objData.ClearParameters()
    call objData.addParameters "@ASP_NAME",advarChar,adParamInput,25, strBrand)
    arrRs = objData.ExecuteSP("SP_DISPLAY_MODELCOMP") '' this SP displays the contents for this Page
    If IsObject(arrRs(0)) Then
        strModel = arrRs(0)("MM.FFSL04_VEH_MKMODL_NAME_N")
    Else
        strModel = ""
    End if
    Response.Write strModel
    If IsObject(arrRs(0)) Then Set arrRs(0)=nothing

Any help will be great.
Thanks
Sri

This line is corrected in the code:
call objData.addParameters ("@ASP_NAME",advarChar,adParamInput,25, strBrand)