Answered by:

no output

Question

hi masters...i have this query in my application. I am not getting anyoutput. plz

REGSQL = "select '<a href=""filetrack.aspx?fname='||chg_filename||'||"">'||chg_filename||'</a>' as ""File No"",file_subject as ""File Subject"",(select RECEIPT_DATE from FILETRANS where filemaster.file_serial_no = FILETRANS.file_serial and filemaster.file_year=FILETRANS.file_year and filetrans.RECEIPT_DATE between trunc(sysdate-6)+(15/24) and least( trunc(sysdate)+(15/24), sysdate) and rownum=1) as ""Received Date"",(select department_name from departments where department_code=filemaster.department_code and rownum=1) as ""Dept"",(select section_name from sections where section_cd=filemaster.section_code and rownum=1 and dept_cd=filemaster.department_code) as ""Section"" from filemaster "

REGSQL = "select '<a href=""filetrack.aspx?fname='||chg_filename||'||"">'||chg_filename||'</a>' as ""File No"",file_subject as ""File Subject"",(select RECEIPT_DATE from FILETRANS where filemaster.file_serial_no = FILETRANS.file_serial and filemaster.file_year=FILETRANS.file_year and filetrans.RECEIPT_DATE between trunc(sysdate-6)+(15/24) and least( trunc(sysdate)+(15/24), sysdate) and rownum=1) as ""Received Date"",(select department_name from departments where department_code=filemaster.department_code and rownum=1) as ""Dept"",(select section_name from sections where section_cd=filemaster.section_code and rownum=1 and dept_cd=filemaster.department_code) as ""Section"" from filemaster "

i have this query in my application. I am not getting anyoutput. my work is to display list of Received File For More Than 3 Daysplz suggest modification in that code.i have 1 table name filemaster and it has columDEPARTMENT_CODESECTION_CODEFILE_SERIAL_NOFILE_YEARFILE_SUBJECTCREATION_DATEOTHER_DETAILSUSER_CODECHG_FILENAMEIDLEDIT2nd table name FILETRANS and has columnsFILE_LETTERFILE_DEPARTMENTFILE_SECTIONFILE_YEARFILE_SERIALLETTER_OFFICE_CODELETTER_DIARY_NOPREV_OFFICE_CODEPREV_OFFICE_DIARY_NODIARY_NOOFFICE_CODERECEIPT_DATERECEIPT_TIMERECEIPT_FLAGTRANSIT_FLAGNEXT_OFFICE_CODEDESP_DATEDESP_TIMEDESP_FLAGNEXT_OFFICE_RECEIPT_STATUSRECEIPT_DATE_TIMEDESPATCH_DATE_TIMEIS_NEWAD_FILE_CODENS_FILE_CODEDELETED_RECR_USER_CODEIDLEDITREMARKSLETTER_FILEIDPUTUP_DATEFILEIDCOM