|
| |
|
|
steveg
Posts: 277
Joined: 10/20/2004
Status: offline
 |
RE: Editing Problem - 8/4/2005 12:44:34
This is now my code:
<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>
</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>
The only problem I have now is the message:
Database Results Error
Description: Extra ) in query expression '(ID = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
Getting desperate 
Steve
|
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Editing Problem - 8/4/2005 13:40:01
See if this helps. Right-click your form and choose Form properties. Then click the Advanced button. For the Name, type ID and for the Value, type, <%=FP_FieldHTML(fp_rs,"ID")%>
The problem is your form is submitting without the ID field in it. So the update code has no idea what record you want to update.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveg
Posts: 277
Joined: 10/20/2004
Status: offline
|
RE: Editing Problem - 8/4/2005 13:58:35
Duane
As one door opens another one shuts. You were right and the message does not appear any more. However, the update does not seem to be happening, the record remains as is???
The form that updates the database has the following code:
<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">
<title>New Page 1</title>
</head>
<body>
<table width="100%" border="1">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="online_physicians_prior_authorisation" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE RESULTS<br>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::'<br>WHERE ID=::ID::" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="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" s-norecordsfound="Record Updated Successfully!" i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-WasTableFormat="TRUE" startspan --><!--#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="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::"
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"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="15099" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" --></tbody>
</table>
</body>
</html>
I feel as though things are really close and I have managed to solve a number of issues by plodding through with guidance from you guys, but I'm just not quite there!!
Cheers
Steve
| |
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Editing Problem - 8/4/2005 14:09:59
Do you get the "Record Updated Successfully! message or do you get an error? And are you checking the database itself to see if the update occurred or are you looking at an ASP page?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveg
Posts: 277
Joined: 10/20/2004
Status: offline
|
RE: Editing Problem - 8/4/2005 14:24:14
Hi Duane
I don't get a record updated successfully message! (and I don't get an error message) and the database is not updated either?
Steve
| |
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Editing Problem - 8/4/2005 14:49:21
Are you sure you are even being directed to the page that performs the update? Does the URL for that page appear in the address bar after you hit the submit button?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveg
Posts: 277
Joined: 10/20/2004
Status: offline
|
RE: Editing Problem - 8/4/2005 18:14:52
I think this is what you wanted, via Notepad:
<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">
<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">
<form METHOD="POST" action="prep_editform.asp">
<p>
<font size="2" face="Verdana">
</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">
6</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">
a
a </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">
a
a</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">
555444</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">
2/21/2005 2:49:55 PM</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=""></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_b" SIZE="15" VALUE=""></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_c" SIZE="15" VALUE=""></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=""></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="ec_b" SIZE="15" VALUE=""></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="ec_c" SIZE="15" VALUE=""></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=""></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="qty_b" SIZE="15" VALUE=""></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="qty_c" SIZE="15" VALUE=""></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" >Chuck Magee</option>
<option value="Sue Ann Syoen" >Sue Ann Syoen</option>
<option value="Jeff Polter" selected>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=""></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="">
<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> </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" selected>No</option>
<option value="Yes" >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="6">
</form>
</body></html>
Let me know if you needed something else
Thanks
Steve
| |
|
|
|
steveg
Posts: 277
Joined: 10/20/2004
Status: offline
|
RE: Editing Problem - 8/4/2005 18:32:17
This is it, this is prep_edit_test.asp which passes the data to prep_editform.asp for updating:
<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">
<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">
<form METHOD="POST" action="prep_editform.asp">
<p>
<font size="2" face="Verdana">
</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">
5</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">
a
a </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">
a
a</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">
777888</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">
3/21/2005 2:49:55 PM</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="777"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_b" SIZE="15" VALUE="777"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="gcn_c" SIZE="15" VALUE="777"></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="777"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="ec_b" SIZE="15" VALUE="777"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="ec_c" SIZE="15" VALUE="777"></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="777"></font></td>
<td width="287" align="center" height="15">
<font face="Verdana">
<input NAME="qty_b" SIZE="15" VALUE="777"></font></td>
<td width="281" align="center" height="15">
<font face="Verdana">
<input NAME="qty_c" SIZE="15" VALUE="777"></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" selected>Chuck Magee</option>
<option value="Sue Ann Syoen" >Sue Ann Syoen</option>
<option value="Jeff Polter" >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="777"></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="">
<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> 7/26/2005 </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" selected>No</option>
<option value="Yes" >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="5">
</form>
</body></html>
This is prep_editform.asp code:
<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">
<title>New Page 1</title>
</head>
<body>
<table width="100%" border="1">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="online_physicians_prior_authorisation" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE RESULTS<br>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::'<br>WHERE ID=::ID::" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="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" s-norecordsfound="Record Updated Successfully!" i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-WasTableFormat="TRUE" startspan --><!--#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="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::"
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"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="15099" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" --></tbody>
</table>
</body>
</html>
Hope this is right
Steve
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Editing Problem - 8/4/2005 19:03:06
Using this code - what is the result of an update?
<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>
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
|
|
steveg
Posts: 277
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,beneficiarysurn | |
Printable Version 