navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
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

Search Forums
 

Advanced search
Recent Posts

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

Microsoft MVP

 

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 and Database >> Editing Problem 		Page: [1] 2 3   next >   >>
 
steveg

 

Posts: 274
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: 6336
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: 274
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: 274
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: 6336
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: 274
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: 6336
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: 6336
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: 274
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: 274
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: 274
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: 274
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: 274
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: 274
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: 274
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: 274
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: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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

§þ:)k¥


(in reply to steveg)
steveg

 

Posts: 274
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: 6336
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: 274
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: 274
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: 274
Joined: 10/20/2004
Status: offline