steveg
Posts: 309
Joined: 10/20/2004
Status: offline
 |
RE: Editing Problem - 8/5/2005 5:27:44
Hi Spooky
I get the same result as before. No successful update message and the update does not happen. I wonder if the way I am getting the information to the page is the problem.
This is the scenario.
I have a group of preparation people, a group of pharmacists and a group of authorisers. The initial record gets entered online by people outside of our company.
Our prep people have a frame which has a left-hand screen (prep_entered_by_display_current.asp) - code follows - <html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 2057 %>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<META HTTP-EQUIV="refresh" CONTENT="3;URL=https://www.4dinform.com/prior_auth/profiles/prep/prep_entered_by_display_current.asp"><% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>null</title>
<base target="rtop">
</head>
<body link="#0000FF" vlink="#0000FF" alink="#0000FF">
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,203,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,135,202,202,202,202,202,202,202,202,202,202,203,135,202,202,202,202,202,135,203,202,202,135,202,202,202,202,203,202" s-dataconnection="online_physicians_prior_authorisation" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-listformat="5" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="ID,physicianforename,physiciansurname,beneficiaryforename,beneficiarysurname,subscriberid,Timestamp" s-criteria="[prep_completed] EQ [No] +" s-order="[Timestamp] + [subscriberid] +" s-sql="SELECT * FROM Results WHERE (prep_completed = 'No') ORDER BY Timestamp ASC,subscriberid ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No Records currently requiring action." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" b-WasTableFormat="FALSE" startspan b-ReplaceDatabaseRegion="FALSE" --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (prep_completed = 'No') ORDER BY Timestamp ASC,subscriberid ASC"
fp_sDefault=""
fp_sNoRecords="No Records currently requiring action."
fp_sDataConn="online_physicians_prior_authorisation"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&physicianforename=202&physiciansurname=202&phone1=202&phone2=202&phone3=202&fax1=202&fax2=202&fax3=202&physicianspecialty=202&beneficiaryforename=202&beneficiarysurname=202&subscriberid=202&dobmonth=202&dobday=202&dobyear=202&D1=202&title=202&name=202&drugname=202&drugstrength=202&adminschedule=202&lengthoftherapy=202&qtyrequested=202&drugname1=202&drugstrength1=202&adminschedule1=202&lengthoftherapy1=202&qtyrequested1=202&drugname2=202&drugstrength2=202&adminschedule2=202&lengthoftherapy2=202&qtyrequested2=202&patientsdiagnosis=203&previoushistoryofamedicalcondition=203&patientseenbyanotherprovideryes=202&patientseenbyanotherprovideryes1=202&prescribersspecialty=203&nameofmedicationprevious=202&reasonforfailureprevious=202&dobmonthprevious=202&dobdayprevious=202&dobyearprevious=202&nameofmedicationprevious1=202&reasonforfailureprevious1=202&dobmonthprevious1=202&dobdayprevious1=202&dobyearprevious1=202&nameofmedicationprevious2=202&reasonforfailureprevious2=202&dobmonthprevious2=202&dobdayprevious2=202&dobyearprevious2=202&procedure=202&findings=202&dobmonthprocedure=202&dobdayprocedure=202&dobyearprocedure=202&procedure1=202&findings1=202&dobmonthprocedure1=202&dobdayprocedure1=202&dobyearprocedure1=202&procedure2=202&findings2=202&dobmonthprocedure2=202&dobdayprocedure2=202&dobyearprocedure2=202&otherinformation=203&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&gcn_a=202&gcn_b=202&gcn_c=202&ec_a=202&ec_b=202&ec_c=202&qty_a=202&qty_b=202&qty_c=202&prep_person_name=202&prep_person_comments=203&prep_person_date=135&prep_completed=202&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&pharm_completed=202&entered_by=202&entered_by_date=135&authorization_a=202&authorization_b=202&authorization_c=202&auth_entry_person_name=202&auth_entry_comments=203&auth_completed=202&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="32770" --><table BORDER="1" width="150" style="border-collapse: collapse" bordercolor="#666666" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#BCBC7A" align="center" width="55">
<font size="1" face="Tahoma">Entry Date</font></td>
<td bgcolor="#BCBC7A" align="center" width="95"><b>
<font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Timestamp<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20579" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font size="1" face="Tahoma">ID</font></td>
<td align="center" width="95"><b><font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="62813" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font size="1" face="Tahoma">Physician</font></td>
<td align="center" width="95"><b><font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>physicianforename<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"physicianforename")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="47906" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"> </td>
<td align="center" width="95"><b><font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>physiciansurname<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"physiciansurname")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45850" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font size="1" face="Tahoma">Beneficiary</font></td>
<td align="center" width="95"><b><font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>beneficiaryforename<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"beneficiaryforename")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="58243" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"> </td>
<td align="center" width="95"><b><font size="1" face="Tahoma">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>beneficiarysurname<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"beneficiarysurname")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="56904" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font size="1" face="Tahoma">Subscriber ID</font></td>
<td align="center" width="95"><b>
<font size="1" face="Tahoma" color="#FF0000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>subscriberid<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"subscriberid")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36330" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font face="Tahoma" size="1">Prep</font></td>
<td align="center" width="95"><b>
<font size="1" face="Tahoma" color="#FF0000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="prep_person_name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>prep_person_name<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"prep_person_name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="47411" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font face="Tahoma" size="1">Pharmacist</font></td>
<td align="center" width="95"><b>
<font size="1" face="Tahoma" color="#FF0000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="pharm_approver" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>pharm_approver<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"pharm_approver")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45861" --></font></b></td>
</tr>
<tr>
<td align="center" width="55"><font face="Tahoma" size="1">Date</font></td>
<td align="center" width="95"><b>
<font size="1" face="Tahoma" color="#FF0000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="pharm_approver_date" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>pharm_approver_date<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"pharm_approver_date")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="61098" --></font></b></td>
</tr>
<tr>
<td align="center" width="150" colspan="2" height="30">
<font size="1" face="Verdana" color="#0000FF">
<a target="rbottom" href="prep_edit_test.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">Edit Record</a></font></td>
</tr>
</table>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" --></body></html> that shows all outstanding documents for them to review. This page refreshes every 3 seconds (currently).
When they wish to work on a document they click the edit option on the document in that screen and the record is opened in the main window with the prep_edit_test.asp document - code follows - <html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<script language="JavaScript" src="date-picker.js"></script>
<title>ID</title>
</head>
<form BOTID="0" METHOD="POST" ACTION="prep_edit_test.asp" name="dateForm">
<body link="#0000FF" vlink="#0000FF" alink="#0000FF">
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,203,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,135,202,202,202,202,202,202,202,202,202,202,203,135,202,202,202,202,202,135,203,202,202,135,202,202,202,202,203,202" s-dataconnection="online_physicians_prior_authorisation" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="7" b-makeform="FALSE" s-recordsource="Results" s-displaycolumns="ID,physicianforename,physiciansurname,beneficiaryforename,beneficiarysurname,subscriberid,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date" s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE (ID = ::ID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="ID=" s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan b-WasTableFormat="FALSE" b-ReplaceDatabaseRegion="FALSE" --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (ID = ::ID::)"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="online_physicians_prior_authorisation"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&physicianforename=202&physiciansurname=202&phone1=202&phone2=202&phone3=202&fax1=202&fax2=202&fax3=202&physicianspecialty=202&beneficiaryforename=202&beneficiarysurname=202&subscriberid=202&dobmonth=202&dobday=202&dobyear=202&D1=202&title=202&name=202&drugname=202&drugstrength=202&adminschedule=202&lengthoftherapy=202&qtyrequested=202&drugname1=202&drugstrength1=202&adminschedule1=202&lengthoftherapy1=202&qtyrequested1=202&drugname2=202&drugstrength2=202&adminschedule2=202&lengthoftherapy2=202&qtyrequested2=202&patientsdiagnosis=203&previoushistoryofamedicalcondition=203&patientseenbyanotherprovideryes=202&patientseenbyanotherprovideryes1=202&prescribersspecialty=203&nameofmedicationprevious=202&reasonforfailureprevious=202&dobmonthprevious=202&dobdayprevious=202&dobyearprevious=202&nameofmedicationprevious1=202&reasonforfailureprevious1=202&dobmonthprevious1=202&dobdayprevious1=202&dobyearprevious1=202&nameofmedicationprevious2=202&reasonforfailureprevious2=202&dobmonthprevious2=202&dobdayprevious2=202&dobyearprevious2=202&procedure=202&findings=202&dobmonthprocedure=202&dobdayprocedure=202&dobyearprocedure=202&procedure1=202&findings1=202&dobmonthprocedure1=202&dobdayprocedure1=202&dobyearprocedure1=202&procedure2=202&findings2=202&dobmonthprocedure2=202&dobdayprocedure2=202&dobyearprocedure2=202&otherinformation=203&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&gcn_a=202&gcn_b=202&gcn_c=202&ec_a=202&ec_b=202&ec_c=202&qty_a=202&qty_b=202&qty_c=202&prep_person_name=202&prep_person_comments=203&prep_person_date=135&prep_completed=202&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&pharm_completed=202&entered_by=202&entered_by_date=135&authorization_a=202&authorization_b=202&authorization_c=202&auth_entry_person_name=202&auth_entry_comments=203&auth_completed=202&"
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="35175" --><form METHOD="POST" action="prep_editform.asp">
<p>
<font size="2" face="Verdana">
<!--webbot bot="PurpleText" preview="Set this form's properties so it submits user input to the appropriate page." --></font></p>
<div align="center">
<center>
<table BORDER="2" width="90%" style="border-collapse: collapse" bordercolor="#FFFFFF" cellpadding="2" cellspacing="1" height="500">
<tr>
<td width="877" height="18" colspan="4">
<p align="center"><b><font size="2" face="Verdana">Prior Authorization
Identifying Details</font></b></td>
</tr>
<tr>
<td width="33%" height="15" bgcolor="#CCCCCC" align="center"><b>
<font size="2" face="Verdana"> ID</font></b></td>
<td width="67%" colspan="3" height="15" bgcolor="#CCCCCC">
<b>
<font face="Verdana" size="2" color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="62813" --></font></b></td>
</tr>
<tr>
<td width="33%" height="15" bgcolor="#CCCCCC" align="center"><b>
<font size="2" face="Verdana">Physician Name</font></b></td>
<td width="67%" colspan="3" height="15" bgcolor="#CCCCCC">
<b>
<font face="Verdana" size="2" color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>physicianforename<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"physicianforename")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="47906" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>physiciansurname<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"physiciansurname")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45850" --> </font>
</b></td>
</tr>
<tr>
<td width="33%" height="15" bgcolor="#CCCCCC" align="center"><b>
<font size="2" face="Verdana">Beneficiary name</font></b></td>
<td width="67%" colspan="3" height="15" bgcolor="#CCCCCC">
<b>
<font face="Verdana" size="2" color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>beneficiaryforename<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"beneficiaryforename")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="58243" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>beneficiarysurname<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"beneficiarysurname")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="56904" --></font></b></td>
</tr>
<tr>
<td width="33%" height="15" bgcolor="#CCCCCC" align="center"><b>
<font size="2" face="Verdana">Subscriber ID</font></b></td>
<td width="67%" colspan="3" height="15" bgcolor="#CCCCCC">
<b>
<font face="Verdana" size="2" color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>subscriberid<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"subscriberid")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36330" --></font></b></td>
</tr>
<tr>
<td width="33%" height="15" bgcolor="#CCCCCC" align="center"><b>
<font size="2" face="Verdana">Date Entered</font></b></td>
<td width="67%" colspan="3" height="15" bgcolor="#CCCCCC">
<b>
<font face="Verdana" size="2" color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,physicianforename,physiciansurname,phone1,phone2,phone3,fax1,fax2,fax3,physicianspecialty,beneficiaryforename,beneficiarysurname,subscriberid,dobmonth,dobday,dobyear,D1,title,name,drugname,drugstrength,adminschedule,lengthoftherapy,qtyrequested,drugname1,drugstrength1,adminschedule1,lengthoftherapy1,qtyrequested1,drugname2,drugstrength2,adminschedule2,lengthoftherapy2,qtyrequested2,patientsdiagnosis,previoushistoryofamedicalcondition,patientseenbyanotherprovideryes,patientseenbyanotherprovideryes1,prescribersspecialty,nameofmedicationprevious,reasonforfailureprevious,dobmonthprevious,dobdayprevious,dobyearprevious,nameofmedicationprevious1,reasonforfailureprevious1,dobmonthprevious1,dobdayprevious1,dobyearprevious1,nameofmedicationprevious2,reasonforfailureprevious2,dobmonthprevious2,dobdayprevious2,dobyearprevious2,procedure,findings,dobmonthprocedure,dobdayprocedure,dobyearprocedure,procedure1,findings1,dobmonthprocedure1,dobdayprocedure1,dobyearprocedure1,procedure2,findings2,dobmonthprocedure2,dobdayprocedure2,dobyearprocedure2,otherinformation,Remote_computer_name,User_name,Browser_type,Timestamp,gcn_a,gcn_b,gcn_c,ec_a,ec_b,ec_c,qty_a,qty_b,qty_c,prep_person_name,prep_person_comments,prep_person_date,prep_completed,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,pharm_completed,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments,auth_completed" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Timestamp<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20579" --></font></b></td>
</tr>
<tr>
<td width="877" colspan="4" height="18">
<p align="center"><b><font face="Verdana" size="2">Drug Recommendations</font></b><hr></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">GCN (A)</font></b></td>
<td width="287" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">GCN (B)</font></b></td>
<td width="281" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">GCN (C)</font></b></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_a")%>"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_b")%>"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_c")%>"></font></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15" bgcolor="#BCBC7A">
<b><font size="2" face="Verdana">EC (A)</font></b></td>
<td width="287" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">EC (B)</font></b></td>
<td width="281" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">EC (C)</font></b></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15">
<font face="Verdana">
<input NAME="ec_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_a")%>"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="ec_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_b")%>"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="ec_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_c")%>"></font></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15" bgcolor="#BCBC7A">
<b><font size="2" face="Verdana">QTY (A)</font></b></td>
<td width="287" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">QTY (B)</font></b></td>
<td width="281" align="center" height="15" bgcolor="#BCBC7A"><b>
<font size="2" face="Verdana">QTY (C)</font></b></td>
</tr>
<tr>
<td width="297" colspan="2" align="center" height="15">
<font face="Verdana">
<input NAME="qty_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_a")%>"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="qty_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_b")%>"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="qty_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_c")%>"></font></td>
</tr>
<tr>
<td width="877" colspan="4" height="18">
<p align="center"><b><font size="2" face="Verdana">Prep Persons Details</font></b><hr></td>
</tr>
<tr>
<td width="297" colspan="2" height="15" bgcolor="#BCBC7A" align="center">
<b><font size="2" face="Verdana">Name</font></b></td>
<td width="574" colspan="2" height="15">
<font face="Verdana">
<select size="1" name="prep_person_name">
<option value="Chuck Magee" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Chuck Magee" Then Response.write(" selected") End If%>>Chuck Magee</option>
<option value="Sue Ann Syoen" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Sue Ann Syoen" Then Response.write(" selected") End If%>>Sue Ann Syoen</option>
<option value="Jeff Polter" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Jeff Polter" Then Response.write(" selected") End If%>>Jeff Polter</option>
</select> </font></td>
</tr>
<tr>
<td width="297" colspan="2" height="15" bgcolor="#BCBC7A" align="center">
<b><font size="2" face="Verdana">Comments</font></b></td>
<td width="574" colspan="2" height="15">
<font face="Verdana">
<input NAME="prep_person_comments" SIZE="80" VALUE="<%=FP_FieldHTML(fp_rs,"prep_person_comments")%>"></font></td>
</tr>
<tr>
<td width="297" colspan="2" height="15" bgcolor="#BCBC7A" align="center">
<b><font size="2" face="Verdana">Date</font></b></td>
<td width="574" colspan="2" height="15">
<font face="Verdana">
<input NAME="prep_person_date" SIZE="20" VALUE="<%=Request("prep_person_date")%>">
<i><font size="1" color="#FF0000">
<map name="FPMap0">
<area href="javascript:show_calendar('dateForm.prep_person_date');" shape="rect" coords="0, 2, 21, 21">
</map><img border="0" src="show-calendar.gif" usemap="#FPMap0"><b><font size="1" face="Verdana"> <a href="javascript:show_calendar('dateForm.prep_person_date');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status='';return true;">Click for calendar</a> <%=fp_rs("prep_person_date")%> </font></b></td>
</tr>
<tr>
<td width="297" colspan="2" height="15" bgcolor="#BCBC7A" align="center">
<b><font size="2" face="Verdana">Completed</font></b></td>
<td width="574" colspan="2" height="15">
<font face="Verdana">
<select size="1" name="prep_completed">
<option value="No" <%If FP_FieldHTML(fp_rs,"prep_completed")="No" Then Response.write(" selected") End If%>>No</option>
<option value="Yes" <%If FP_FieldHTML(fp_rs,"prep_completed")="Yes" Then Response.write(" selected") End If%>>Yes</option>
</select> </tr>
<tr>
<td COLSPAN="3" width="590" height="26">
<p align="center">
<font face="Verdana">
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></font></td>
</tr>
</table>
</center>
</div>
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
</form>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" --></body></html> which then passes the info to prep_editform.asp to update the database - code follows - <html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<table width="100%" border="1">
<thead>
</thead>
<tbody><!--#include file="../../../_fpclass/fpdblib.inc"-->
<%
fp_sQry="UPDATE RESULTS SET gcn_a='::gcn_a::', gcn_b='::gcn_b::', gcn_c='::gcn_c::', ec_a='::ec_a::', ec_b='::ec_b::', ec_c='::ec_c::', qty_a='::qty_a::', qty_b='::qty_b::', qty_c='::qty_c::', prep_person_name='::prep_person_name::', prep_person_comments='::prep_person_comments::', prep_person_date='::prep_person_date::' WHERE ID=::ID::"
response.write fp_sQry
response.end
fp_sDefault="gcn_a=a&gcn_b=a&gcn_c=a&ec_a=a&ec_b=a&ec_c=a&qty_a=a&qty_b=a&qty_c=a&prep_person_name=a&prep_person_comments=a&prep_person_date=01/01/01&ID=999999"
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">Record Updated Successfully!</td></tr>"
fp_sDataConn="online_physicians_prior_authorisation"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
</body>
</html>
The prep_editform.asp code shown here is currently the last code that you sent me.
The prep person may add some info and save and then possibly add some more and then save. They could make a number of visits over a few days. When the record is complete they will mark it as complete and then it will automatically (on refresh) be removed from their display screen (prep_entered_by_display_current.asp) and will appear in the display screen for the pharmacist, ready for them to update.
Does the refreshing cause a problem? I hope this background helps.
Steve
|
Printable Version 
ky 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread