CONVERT ID TO NAME

'CONVERT ID TO NAME

'SAMPLE INPUT : 2345

'SAMPLE OUTPUT: MADHAN KUMAR

<%

function convertID2Name(INPUT_ID)

if INPUT_ID<>"" then

set ObjRsID2Name=myconn.execute("select c_institute_name from master_institute
where ID='"& INPUT_ID &"'")

if not ObjRsID2Name.eof then



convertID2Name=ObjRsID2Name("Name")

else

convertID2Name=""

end if

else

convertID2Name=""

end if

end function

%>