SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Emp_ID = '#FORM.Emp_ID#' AND status =0 SELECT files.*,pPatients.Pt_Last,pPatients.Pt_First FROM #Request.prefix_db_agency#.files JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = files.PatientId AND pPatients.status < 2 WHERE files.id IN (#FORM.file_id#) AND files.AgencyId = '#session.AgencyId#' SELECT pg_files.*,pPatients.Pt_Last,pPatients.Pt_First FROM #Request.prefix_db_agency#.pg_files JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pg_files.Patient_Id AND pPatients.status < 2 WHERE pg_files.id = '#FORM.file_id#' AND pg_files.Agency_Id = '#session.AgencyId#' request.myPdf = fileReadBinary(getfilename); request.myPdf = toBase64( request.myPdf ); //request.myPdf = toBinary( request.myPdf ); UPDATE #Request.prefix_db_agency#.files #Request.prefix_db_agency#.pg_files SET faxsend_to = , faxsent_time = WHERE id IN ()