OutFront Forums
     Home    Register     Search      Help      Login    

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
 

Editing Problem

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP, PHP, and Database >> Editing Problem 		Page: [1] 2 3   next >   >>
 
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		Editing Problem - 7/14/2005 7:35:36   
Hi Guys

I have a database that can be filled in on-line. I have some people that will make changes to the data (they will add status info into particular fields). I have tried to create an edit form for the first user profile (the people who see the new database record first. They need to add some info and some quantities, their name, comments and a date.

I created a form called edit_test.asp. I have not formatted or finalised the layout, but I have included all the fields that need to be updated. 
<html>

<head>
<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="Content-Type" content="text/html; charset=windows-1252">
<title>ID</title>
</head>

<body>

<form method="POST" name="editform.asp">
  <p>ID   <input type="text" name="ID" size="20"></p>
  <p>gcn_a   <input type="text" name="gcn_a" size="20"></p>
  <p>gcn_b   <input type="text" name="gcn_b" size="20"></p>
  <p>gcn_c   <input type="text" name="gcn_c" size="20"></p>
  <p>ec_a   <input type="text" name="ec_a" size="20"></p>
  <p>ec_b   <input type="text" name="ec_b" size="20"></p>
  <p>ec_c   <input type="text" name="ec_c" size="20"></p>
  <p>qty_a   <input type="text" name="qty_a" size="20"></p>
  <p>qty_b   <input type="text" name="qty_b" size="20"></p>
  <p>qty_c   <input type="text" name="qty_c" size="20"></p>
  <p>prep person name   <input type="text" name="gcnc3" size="20"></p>
  <p>prep person comments  
  <textarea rows="2" name="prep_person_comments" cols="40"></textarea></p>
  <p>date 
  <!--webbot bot="Validation" S-Data-Type="String" B-Allow-Digits="TRUE" S-Allow-Other-Chars="/" B-Value-Required="TRUE" I-Minimum-Length="6" --><input type="text" name="prep_person_date" size="20"></p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>


I then created a form called editform.asp and created the custom DRW. 

<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>
    <!--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=&amp;gcn_b=&amp;gcn_c=&amp;ec_a=&amp;ec_b=&amp;ec_c=&amp;qty_a=&amp;qty_b=&amp;qty_c=&amp;prep_person_name=&amp;prep_person_comments=&amp;prep_person_date=&amp;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="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=&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=&ID="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</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="33211" --><!--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="65064" --></tbody>
</table>

</body>

</html>


This was following the Spooky Update Records training material. The form accepts input and on clicking submit the data disappears. It does not get into the database??

I would like to refine it further when I get it working )(LOL!) so that I could have the data that is currently in the fields showing prior to updating and some way of showing that the update has happened afterwards. Still better walk before I run.

All help greatly appreciated (and needed!!!)

Steve
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Editing Problem - 7/14/2005 10:50:35   
There may be other issues, but start by fixing this line:

<form method="POST" name="editform.asp">

It needs an action, i.e.,

<form method="POST" name="myForm" action="editform.asp">

_____________________________

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.

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/14/2005 11:13:33   
quote:

<form method="POST" name="myForm" action="editform.asp">


How odd? I looked at the code and couldn't find the line you mentioned?

I have copied and pasted again. 

<html>

<head>
<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="Content-Type" content="text/html; charset=windows-1252">
<title>ID</title>
</head>

<body>

<form method="POST" name="FrontPage_Form1" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript">
  <p>ID   <input type="text" name="ID" size="20"></p>
  <p>gcn_a   <input type="text" name="gcn_a" size="20"></p>
  <p>gcn_b   <input type="text" name="gcn_b" size="20"></p>
  <p>gcn_c   <input type="text" name="gcn_c" size="20"></p>
  <p>ec_a   <input type="text" name="ec_a" size="20"></p>
  <p>ec_b   <input type="text" name="ec_b" size="20"></p>
  <p>ec_c   <input type="text" name="ec_c" size="20"></p>
  <p>qty_a   <input type="text" name="qty_a" size="20"></p>
  <p>qty_b   <input type="text" name="qty_b" size="20"></p>
  <p>qty_c   <input type="text" name="qty_c" size="20"></p>
  <p>prep person name   <input type="text" name="gcnc3" size="20"></p>
  <p>prep person comments  
  <textarea rows="2" name="prep_person_comments" cols="40"></textarea></p>
  <p>date 
  <!--webbot bot="Validation" s-data-type="String" b-allow-digits="TRUE" s-allow-other-chars="/" b-value-required="TRUE" i-minimum-length="6" --><input type="text" name="prep_person_date" size="20"></p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>


I only copied and pasted previously, why should it have changed?

Steve

(in reply to BeTheBall)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/14/2005 11:18:32   
You're on the money Duane.

I changed the line to:

<form method="POST" name="FrontPage_Form1" action="editform.asp" language="JavaScript">

and lo and behold the database has been updated.

Couple of questions, after the update I got a message saying "No Records Returned". Why would this be?

What do I need to do to show what has been updated?
How do I display the content of the fields before I update with my data?

Steve


(in reply to steveg)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Editing Problem - 7/14/2005 11:18:43   
OK, well now it would be this line:

<form method="POST" name="FrontPage_Form1" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" action="editform.asp">

_____________________________

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.

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/14/2005 11:19:53   
I removed the onsubmit option - what will this do?

Steve

(in reply to BeTheBall)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Editing Problem - 7/14/2005 11:36:01   
The onsubmit option calls the javascript function that validates the form field entries. You probably don't want to delete it.

As for the "No records returned" message. That is the default for FP. To change it, right-click your database results region and click Database Results Properties. This will launch the wizard. Go to step 3 and choose More Options. There at the bottom you will see a text box prefilled with No records returned. Delete that and put in your own message, say, Update successful.

You other question is a bit more complicated. The easiest way to do it is to let the DRW create your edit form. I know there have been posts on how to do it. In fact I am sure I have posted the process a few times. Let me see if I can find it so I don't have to type it all again. (Forgive the laziness :))

_____________________________

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.

(in reply to steveg)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Editing Problem - 7/14/2005 11:49:07   
Revisit this thread:

http://www.frontpagewebmaster.com/m-226014/key-edit%252Crecord/tm.htm#226053

You may remember it as you posted in it.

_____________________________

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.

(in reply to BeTheBall)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/14/2005 11:53:38   
You see, some things just don't stick!

Thanks Duane

(in reply to BeTheBall)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/21/2005 10:02:53   
Hi Duane

I looked at that link but I could not see that I had posted in it?? Never mind though, I have made some progress but have a slight sticking point.

I have developed a frame that has ad DRW page displaying all records for a particular profile that refreshes every few seconds. I have added a hyperlink to each record that will open the selected record in the main area of the frame and the person can add in their information. The result of adding this info in means that on the next refresh the record will not be there and will appear in the next user in the chains frame.

The update works if you type in the record ID and the data you need to add but I cannot get the data from the record selected displayed in the frame when editing. What am I missing?

Here is the code for the page that displays the records 
<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/entered_by/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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" 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,135,203,202,135,202,202,202,202,203" 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_person_name] EQ [TBA] + [pharm_approver] EQ [TBA] + [entered_by] EQ [TBA] +" s-order="[Timestamp] + [subscriberid] +" s-sql="SELECT * FROM Results WHERE (prep_person_name =  'TBA' AND pharm_approver =  'TBA' AND entered_by =  'TBA') 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_person_name =  'TBA' AND pharm_approver =  'TBA' AND entered_by =  'TBA') 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&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&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&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="35864" --><table BORDER="1" width="150" style="border-collapse: collapse" bordercolor="#666666" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#C0C0C0" align="center" width="55">
    <font size="1" face="Tahoma">Entry Date</font></td>
    <td bgcolor="#C0C0C0" 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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Timestamp<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physicianforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physiciansurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiaryforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiarysurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>subscriberid<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="prep_person_name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>prep_person_name<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="pharm_approver" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>pharm_approver<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="pharm_approver_date" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>pharm_approver_date<font size="-1">&gt;&gt;</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="edit_test.asp?ID=<%=FP_FieldVal(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>


and here is the code for the edit_test.asp page 

<html>

<head>
<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="Content-Type" content="text/html; charset=windows-1252">
<title>ID</title>
</head>

<body>

<form method="POST" name="FrontPage_Form1" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" action="../../test/editform.asp"> 
  <div align="center">
    <center>
    <table border="1" cellpadding="4" style="border-collapse: collapse" bordercolor="#FFFFFF" width="75%" id="AutoNumber1" bgcolor="#BCBC7A">
      <tr>
        <td width="50%" colspan="2" align="center">
        <p align="right"><b><font size="2" face="Verdana">Prior Auth ID </font>
        </b></td>
        <td width="50%" colspan="2" align="center">
        <p align="left"><font face="Verdana"><b> <input type="text" name="ID" size="20"></b></font></td>
      </tr>
      <tr>
        <td width="33%" align="center"><b><font size="2" face="Verdana">GCN (a)</font></b></td>
        <td width="33%" colspan="2" align="center"><b>
        <font size="2" face="Verdana">GCN (b)</font></b></td>
        <td width="34%" align="center"><b><font size="2" face="Verdana">GCN (c)</font></b></td>
      </tr>
      <tr>
        <td width="33%" align="center"><font face="Verdana"><b> 
        <input type="text" name="gcn_a" size="20" value="<%=request ("gcn_a")%>"></b></font></td>
        <td width="33%" colspan="2" align="center"><font face="Verdana"><b> 
        <input type="text" name="gcn_b" size="20" value="<%=request ("gcn_b")%>"></b></font></td>
        <td width="34%" align="center"><font face="Verdana"><b> 
        <input type="text" name="gcn_c" size="20" value="<%=request ("gcn_c")%>"></b></font></td>
      </tr>
      <tr>
        <td width="33%" align="center"><b><font size="2" face="Verdana">EC (a)</font></b></td>
        <td width="33%" colspan="2" align="center"><b>
        <font size="2" face="Verdana">EC (b)</font></b></td>
        <td width="34%" align="center"><b><font size="2" face="Verdana">EC (c)</font></b></td>
      </tr>
      <tr>
        <td width="33%" align="center"><font face="Verdana"><b> <input type="text" name="ec_a" size="20"></b></font></td>
        <td width="33%" colspan="2" align="center"><font face="Verdana"><b> <input type="text" name="ec_b" size="20"></b></font></td>
        <td width="34%" align="center"><font face="Verdana"><b> <input type="text" name="ec_c" size="20"></b></font></td>
      </tr>
      <tr>
        <td width="33%" align="center"><b><font size="2" face="Verdana">QTY (a)</font></b></td>
        <td width="33%" colspan="2" align="center"><b>
        <font size="2" face="Verdana">QTY (b)</font></b></td>
        <td width="34%" align="center"><b><font size="2" face="Verdana">QTY (c)</font></b></td>
      </tr>
      <tr>
        <td width="33%" align="center"><font face="Verdana"><b> <input type="text" name="qty_a" size="20"></b></font></td>
        <td width="33%" colspan="2" align="center"><font face="Verdana"><b> <input type="text" name="qty_b" size="20"></b></font></td>
        <td width="34%" align="center"><font face="Verdana"><b> <input type="text" name="qty_c" size="20"></b></font></td>
      </tr>
      <tr>
        <td width="50%" colspan="2" align="center"><b>
        <font size="2" face="Verdana">Prep Persons Name</font></b></td>
        <td width="50%" colspan="2" align="center"><b>
        <font size="2" face="Verdana">Date Prep Info Entered</font></b></td>
      </tr>
      <tr>
        <td width="50%" colspan="2" align="center">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="prep_person_name">
        <option>Select a Name</option>
        <option>Jerry Borsand</option>
        <option>Steve Goode</option>
        <option>Chuck Magee</option>
        <option>Jeff Polter</option>
        <option>Sue Ann Syoen</option>
        </select></td>
        <td width="50%" colspan="2" align="center"><font face="Verdana"><b>
        <!--webbot bot="Validation" s-data-type="String" b-allow-digits="TRUE" s-allow-other-chars="/" b-value-required="TRUE" i-minimum-length="6" --><input type="text" name="prep_person_date" size="20"></b></font></td>
      </tr>
      <tr>
        <td width="100%" colspan="4" align="center"><b>
        <font size="2" face="Verdana">Prep Persons Comments</font></b></td>
      </tr>
      <tr>
        <td width="100%" colspan="4" align="center"><font face="Verdana"><b>
  <textarea rows="2" name="prep_person_comments" cols="40"></textarea></b></font></td>
      </tr>
    </table>
    </center>
  </div>
  <p align="center"><b><font size="2" face="Verdana">  </font></b>
  <font face="Verdana"><b><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></b></font></p>
</form>

</body>

</html>


and here is the code for editform.asp 

<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=&amp;gcn_b=&amp;gcn_c=&amp;ec_a=&amp;ec_b=&amp;ec_c=&amp;qty_a=&amp;qty_b=&amp;qty_c=&amp;prep_person_name=&amp;prep_person_comments=&amp;prep_person_date=&amp;ID=" 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=&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=&ID="
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="62319" --><!--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 I am close but I am stuck!!

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/25/2005 11:31:42   
Anyone got any ideas?

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/25/2005 14:21:18   
Sorry to be a pain asking, but I am really close. I can edit I just can't see the current content of the fields before I edit.

Really need some help if pos.

Ta

Steve

(in reply to steveg)
rubyaim

 

Posts: 757
Joined: 6/22/2005
Status: offline

  		RE: Editing Problem - 7/25/2005 18:33:12   
Hi Steve, had a quick look, and I can't see anything on the actual edit form page that calls in the ID of the record to be edited.

On the page that displays the records, your Edit link shows:

href="edit_test.asp?ID=<%=FP_FieldVal(fp_rs,"ID")

On the actual form though, I can't see where the ID is pulled in? You are passing the ID to the edit page, but not actually collecting it there...

For pages like this, I always do what Duane posted above, just use the DRW to query the database with a form - quick and easy :) It may suit you as you are using the DRW elsewhere.

It should not take you too long if you want to go this way. Basically go to >Insert > Database > Results - step through the DRW as per normal. In the criteria select where ID = ID. In Step 4 select "List - one field per item" and in List options select "Text fields".

The link Duane posted above has all the info.

Does this help any? I could have missed something though, only had a quick look.

Sally

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/26/2005 7:28:19   
Sally

Thanks for that. I have done what you both suggested. I am able to get the content displayed!!!

However, unless I enter something in every field the update will not happen. I get the message:

Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
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.

Normally in a search form query I would generate default values with this kind of message and that would solve it but I am only able to generate a default for the ID field (my criteria).

How do I get around this? Although this element is completed by one person, they might enter the data at different times until all fields are complete and some fields may never be completed!

Steve

(in reply to rubyaim)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/26/2005 8:01:54   
....and one further thing. Can I stop some of the fields from being updated? I have used about 6 fields to show that it is the right record but I would like the user not to be able to change those fields, only the ones they are responsible for. To make this a little clearer I have included the latest version of the 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>ID</title>
</head>

<body>

<!--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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" 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,135,203,202,135,202,202,202,202,203" 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=9999999999" 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" --><!--#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=9999999999"
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&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&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&"
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="27997" --><form METHOD="POST">
  <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>
  <table BORDER="2" width="90%" style="border-collapse: collapse" bordercolor="#FFFFFF" cellpadding="2" cellspacing="1" height="500">
    <tr>
      <td width="765" height="18" colspan="4">
      <p align="center"><b><font size="2" face="Verdana">Prior Authorization 
      Identifying Details</font></b></td>
    </tr>
    <tr>
      <td width="163" height="18" bgcolor="#CCCCCC"><b>
      <font size="2" face="Verdana">ID</font></b></td>
      <td width="602" colspan="3" height="18" bgcolor="#CCCCCC">
      <font face="Verdana">
      <input NAME="ID" SIZE="10" VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>" style="font-family: Verdana; color: #666666; font-size: 10pt"></font></td>
    </tr>
    <tr>
      <td width="163" height="18" bgcolor="#CCCCCC"><b>
      <font size="2" face="Verdana">Physician Name</font></b></td>
      <td width="602" colspan="3" height="18" bgcolor="#CCCCCC">
      <font face="Verdana">
      <input NAME="physicianforename" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"physicianforename")%>" style="font-family: Verdana; font-size: 10pt; color: #666666"></font><font size="2" face="Verdana">
      </font><font face="Verdana">
      <input NAME="physiciansurname" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"physiciansurname")%>" style="font-family: ve; font-size: 10pt; color: #666666"></font></td>
    </tr>
    <tr>
      <td width="163" height="18" bgcolor="#CCCCCC"><b>
      <font size="2" face="Verdana">Beneficiary name</font></b></td>
      <td width="602" colspan="3" height="18" bgcolor="#CCCCCC">
      <font face="Verdana">
      <input NAME="beneficiaryforename" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"beneficiaryforename")%>" style="font-family: ve; font-size: 10pt; color: #666666"></font><font size="2" face="Verdana">
      </font><font face="Verdana">
      <input NAME="beneficiarysurname" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"beneficiarysurname")%>" style="font-family: ve; font-size: 10pt; color: #666666"></font></td>
    </tr>
    <tr>
      <td width="163" height="18" bgcolor="#CCCCCC"><b>
      <font size="2" face="Verdana">Subscriber ID</font></b></td>
      <td width="201" height="18" bgcolor="#CCCCCC">
      <font face="Verdana">
      <input NAME="subscriberid" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"subscriberid")%>" style="font-family: Verdana; font-size: 10pt; color: #666666"></font></td>
      <td width="201" height="18" bgcolor="#CCCCCC">
      <p align="center"><b><font size="2" face="Verdana">Date Entered</font></b></td>
      <td width="200" height="18" bgcolor="#CCCCCC">
      <p align="center"><font face="Verdana">
      <input NAME="Timestamp" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"Timestamp")%>" style="font-family: Verdana; font-size: 10pt; color: #666666"></font></td>
    </tr>
    <tr>
      <td width="765" colspan="4" height="18">
      <p align="center"><b><font face="Verdana" size="2">Drug Recommendations</font></b></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">GCN (A)</font></b></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">GCN (B)</font></b></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">GCN (C)</font></b></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="gcn_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_a")%>"></font></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="gcn_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_b")%>"></font></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="gcn_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"gcn_c")%>"></font></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A">
      <b><font size="2" face="Verdana">EC (A)</font></b></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">EC (B)</font></b></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">EC (C)</font></b></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="ec_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_a")%>"></font></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="ec_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_b")%>"></font></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="ec_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"ec_c")%>"></font></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A">
      <b><font size="2" face="Verdana">QTY (A)</font></b></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">QTY (B)</font></b></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">QTY (C)</font></b></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="qty_a" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_a")%>"></font></td>
      <td width="34%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="qty_b" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_b")%>"></font></td>
      <td width="33%" align="center" height="18" bgcolor="#BCBC7A">
      <font face="Verdana">
      <input NAME="qty_c" SIZE="15" VALUE="<%=FP_FieldHTML(fp_rs,"qty_c")%>"></font></td>
    </tr>
    <tr>
      <td width="99%" colspan="4" height="18">
      <p align="center"><b><font size="2" face="Verdana">Prep Persons Details</font></b></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">Name</font></b></td>
      <td width="66%" colspan="2" height="18">
      <font face="Verdana">
      <input NAME="prep_person_name" SIZE="25" VALUE="<%=FP_FieldHTML(fp_rs,"prep_person_name")%>"></font></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">Comments</font></b></td>
      <td width="66%" colspan="2" height="18">
      <font face="Verdana">
      <input NAME="prep_person_comments" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"prep_person_comments")%>"></font></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">Date</font></b></td>
      <td width="66%" colspan="2" height="18">
      <font face="Verdana">
      <input NAME="prep_person_date" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"prep_person_date")%>"></font></td>
    </tr>
    <tr>
      <td width="33%" colspan="2" height="18" bgcolor="#BCBC7A"><b>
      <font size="2" face="Verdana">Completed</font></b></td>
      <td width="66%" colspan="2" height="18">
      <font face="Verdana">
      <input NAME="prep_completed" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"prep_completed")%>"></font></td>
    </tr>
    <tr>
      <td COLSPAN="3" width="475" height="26">
      <p align="center">
      <font face="Verdana">
      <input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></font></td>
    </tr>
  </table>
</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>


A slightly desperate but very hopeful

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/26/2005 8:21:03   
........apologies, but also would like to know if textboxes can be used instead of a text field?

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/26/2005 8:25:02   
Added to my last post, can I have a drop down box to select the name of the person updating the record and also to select Yes this record is complete (which by definition will move it to the next group in the company)?

Steve

(in reply to steveg)
Spooky

 

Posts: 26681
Joined: 11/11/1998
From: Middle Earth
Status: online

  		RE: Editing Problem - 7/26/2005 15:28:54   
If you want a non editable field, just "write" the value to the page and dont display it in a text box.
If the value needs submitting to database still, then place the actual value in a hidden text box.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/26/2005 17:12:05   
Thanks Spooky.

That was so obvious but ....duh!! I just couldn't see it.

Anyone got any ideas on text areas and drop downs?

Steve

(in reply to Spooky)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Editing Problem - 7/26/2005 17:49:07   
Here is an example of a dropdown used in an edit form. You simply replace the text box with something like this:

<select size="1" name="Position">
<option value="Manager" <%If FP_FieldHTML(fp_rs,"Position")="Manager" Then Response.write(" selected") End If%>>Manager</option>
<option value="Lead" <%If FP_FieldHTML(fp_rs,"Position")="Lead" Then Response.write(" selected") End If%>>Lead</option>
<option value="Contact Rep." <%If FP_FieldHTML(fp_rs,"Position")="Contact Rep." Then Response.write(" selected") End If%>>Contact Rep.</option>
</select>

The dropdown will display the options available and the one that matches the current record will be pre-selected.

_____________________________

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.

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/28/2005 10:25:14   
Thanks for the patience guys. If I want to write the value to the page rather than just displaying it in a field how do I change the code. I currently have this piece for example: 

<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">
      <font face="Verdana">
      <input NAME="physicianforename" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"physicianforename")%>" style="font-family: Verdana; font-size: 10pt; color: #666666"></font><font size="2" face="Verdana">
      </font><font face="Verdana">
      <input NAME="physiciansurname" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"physiciansurname")%>" style="font-family: ve; font-size: 10pt; color: #666666"></font></td>
    </tr>


I created a basic drw to display and it seemed that I still had the field reference but without the input instruction. I tried to remove the input element and lost the complete field.

Got a clue for a slow starter?

Steve

(in reply to BeTheBall)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/28/2005 11:15:15   
OK, Ignore that last post. I figured it out....wasn't rocket science was it.....told you I was slow.

Now I'm gonna tangle with the pull-down to see if I understand that one!

Still seem to have that problem with needing to complete all the fields otherwise the update doesn't happen!!

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/28/2005 11:48:29   
I think I have got to grips with the pull-downs thank you.

Just need to get the update to happen if I have only completed one or two fields.

Here is my latest version of the 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>ID</title>
</head>

<body>

<!--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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" 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,135,203,202,135,202,202,202,202,203" 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=9999999999" 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" --><!--#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=9999999999"
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&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&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&"
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="27997" --><form METHOD="POST">
  <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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physicianforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physiciansurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiaryforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiarysurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>subscriberid<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Timestamp<font size="-1">&gt;&gt;</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></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></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="Position"> 
<option value="Jeff Polter" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Jeff Polter" Then Response.write(" selected") End If%>>Jeff Polter</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="Chuck Magee" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Chuck Magee" Then Response.write(" selected") End If%>>Chuck Magee</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="<%=FP_FieldHTML(fp_rs,"prep_person_date")%>">
      <i><font size="1" color="#FF0000">date format should be mm/dd/yyyy</font></i></font></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="Position"> 
<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>


Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/28/2005 12:16:12   
While I was waiting....(idle hands and all that) I tried to adapt a date picker that Spooky told me about in a previous post (which I have working elsewhere) but I seem to have a slight snag. The calendar window doesn't pop up abd in the grey bar at the bottom I get an Error on Page message. When I open the debugger I get the message"Object Expected"

Any thoughts? Here is my updated 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>ID</title>
</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" 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,135,203,202,135,202,202,202,202,203" 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=9999999999" 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" --><!--#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=9999999999"
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&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&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&"
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="27997" --><form METHOD="POST">
  <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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physicianforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physiciansurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiaryforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiarysurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>subscriberid<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Timestamp<font size="-1">&gt;&gt;</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="Position"> 
<option value="Jeff Polter" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Jeff Polter" Then Response.write(" selected") End If%>>Jeff Polter</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="Chuck Magee" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Chuck Magee" Then Response.write(" selected") End If%>>Chuck Magee</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="<%=FP_FieldHTML(fp_rs,"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></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="Position"> 
<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>


By the way, I do solemnly swear that I will not make any further changes until somebody has replied.

And I can still only update if I provide data in all the updatable fields.

Steve

(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 7/28/2005 14:02:26   
I think this thread looks messy. I guess that as I keep re-visiting the code and trying things I am making minor changes. To clarify, I will summarise my issues:

1. I cannot update with blank fields. I have read previous threads on this and all of my fields are text, apart from one which is a date. I have checked in the database and have set default value to Null and ensured that zero length is allowed. It still does not seem to like to update blanks.

2. I have updated two fields to drop-downs but I do not appear to be getting the value from the database displayed, I just get to see the firt option in the drop down?

3. I have tried to use a Date Picker function to make it user friendly (this is a utility that Spooky recommended to me previously and I have working elsewhere on the site, albeit in a search form). The calendar window does not appear and I get an Error on Page message in the grey status bar. In debugger I am told that an object is missing.

Here is my current 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>ID</title>
</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" 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,135,203,202,135,202,202,202,202,203" 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=9999999999" 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" --><!--#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=9999999999"
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&approved_ a=202&approved_b=202&approved_c=202&pharm_approver=202&pharm_approver_date=135&pharmacist_comments=203&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&"
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="27997" --><form METHOD="POST">
  <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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physicianforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physicianforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="physiciansurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>physiciansurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiaryforename" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiaryforename<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="beneficiarysurname" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>beneficiarysurname<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="subscriberid" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>subscriberid<font size="-1">&gt;&gt;</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,approved_ a,approved_b,approved_c,pharm_approver,pharm_approver_date,pharmacist_comments,entered_by,entered_by_date,authorization_a,authorization_b,authorization_c,auth_entry_person_name,auth_entry_comments" s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Timestamp<font size="-1">&gt;&gt;</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="Position"> 
<option value="Jeff Polter" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Jeff Polter" Then Response.write(" selected") End If%>>Jeff Polter</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="Chuck Magee" <%If FP_FieldHTML(fp_rs,"prep_person_name")="Chuck Magee" Then Response.write(" selected") End If%>>Chuck Magee</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="<%=FP_FieldHTML(fp_rs,"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></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="Position"> 
<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>


I hope I have clarified my issues and I really hope that somebody will respond to me soon.

Cheers

Steve

(in reply to steveg)
Spooky

 

Posts: 26681
Joined: 11/11/1998
From: Middle Earth
Status: online

  		RE: Editing Problem - 7/28/2005 16:15:05   

2) What does the browser source code look like for those dropdowns?
Does this code work any better? 
<select size="1" name="Position"> 
<option value="No" <%If lcase(fp_rs("prep_completed"))="no" Then Response.write(" selected") End If%>>No</option> 
<option value="Yes" <%If lcase(fp_rs("prep_completed"))="yes" Then Response.write(" selected") End If%>>Yes</option> 
</select>

3) I dont see the JS include for the date picker?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 8/1/2005 10:24:36   
Hi Spooky

I have changed my drop down code to this:

<select size="1" name="Position">
<option value="Jeff Polter" <%If lcase(fp_rs("prep_person_name"))="Jeff Polter" Then Response.write(" selected") End If%>>Jeff Polter</option>
<option value="Sue Ann Syoen" <%If lcase(fp_rs("prep_person_name"))="Sue Ann Syoen Polter" Then Response.write(" selected") End If%>>Sue Ann Syoen</option>
<option value="Chuck Magee" <%If lcase(fp_rs("prep_person_name"))="Chuck Magee" Then Response.write(" selected") End If%>>Chuck Magee</option>
<option value="David Whyte" <%If lcase(fp_rs("prep_person_name"))="David Whyte" Then Response.write(" selected") End If%>>David Whyte</option>
</select>

It is easier for me to test the name completed field as the completed status moves the record to a different display screen. However, I have used the same syntax as you suggested. It still doesn't seem to pickup the record data, just the first name in the drop down?

Steve

(in reply to Spooky)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 8/1/2005 10:29:11   
Spooky

You were right, the include statement was missing. I have added it and the calender appears fine. However, the date is not being transferred to the date field?? and the calendar is remaining on the screen. In my other instance of this script the calendar disappears as the date is entered in the field. I am sure that this should point to something obvious, but then again....

Also, I am still unable to update just a few fields and have to update them all to get the update accepted! This is my biggest problem as this is a must for the users!! Does anybody have any ideas?

Steve

< Message edited by steveg -- 8/1/2005 10:50:05 >

(in reply to steveg)
Spooky

 

Posts: 26681
Joined: 11/11/1998
From: Middle Earth
Status: online

  		RE: Editing Problem - 8/1/2005 14:06:53   
Can you write the actual value after the box to see visually what its trying to do?

eg :
</select> <%=fp_rs("prep_person_name")%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to steveg)
steveg

 

Posts: 309
Joined: 10/20/2004
Status: offline

  		RE: Editing Problem - 8/4/2005 9:48:05   
Hi Spooky & Duane

1. I checked the actual value which is showing the value from the database correctly. I was thinking that the drop-down box would default to the name that was in the database. Is this not what I should expect. Should I write the value from the field and then allow the drop-down to be used to change the value if required? I have now solved this one, it was down to a syntax issue.

2. The date field displays correctly and as said previously the calendar appears but the selected value is not entered into the field and the calendar remains on the screen. Solved this, I had the BotID statement missing.

3. When I try to update I get the following message:

Database Results Error
Description: Syntax error (missing operator) 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.

which would appear to indicate a problem with the ID field. Is this because I have changed the ID from an editable field to just a field that is being written to the screen? I remember reading somewhere (on here) that I can have it as a hidden field. nIs this what I need to do and if so how do I do that?

Thanx

Steve

< Message edited by steveg -- 8/4/2005 10:09:00 >

(in reply to Spooky)
Page:   [1] 2 3   next >   >>

All Forums >> Web Development >> ASP, PHP, and Database >> Editing Problem 		Page: [1] 2 3   next >   >>
Jump to: 1





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
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Copyright © 2009 Thomas Brunt's OutFront Inc. All Rights Reserved.