Posted on: 12/7/2013 5:00:50 AM | Views : 835

hi guys
I have an applicaation in which govt sector dept user sent file to another user... eg. home dept user sent  1 file to defence dept user. and there is facility that defence user will receive that file by going  to particular page.. if user didnt receive file sent by other user than that will be called as pending file.i have to display that list of pending file of each user .
i have 1 query which is displaying list of pending file of a user on page load:
ssql = "select '<a href=""file/filetrack.aspx?fname='||chg_filename||'&'||'fdept='||filemaster.department_code|| '&'||'fsection='||filemaster.section_code||'&'||'fyear='||filemaster.file_year||'&'||'fserial='||filemaster.file_serial_no||'"">'||chg_filename||'</a>' as ""File Name"",file_subject as ""Subject"",off ...

Go to the complete details ...