H
Hlarkin
I am using frontpage 2003 & access 2003 I am trying to build a simple
database where people can add, update, & edit dog information. I have
sucessfully been able to get DRW to add dog, view, search for dogs, but I
can't get it to update or edit information on dogs already in the database.
I got it to work one time, but can't remember what I did & now it's not
working again. Please help. I've looked everywhere to find a way to do this
but there's not really any answers.
I want it in an .asp page. I am starting simple with for instance the
callname & akc number, once I figure it out I can add the others.
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,name,sireID,damID,PreTit,SuffTit,callname,DOB,genID,ColorID,Owner,Breeder,DOD,website,Hips,Eyes,elbows,CNM,Honorifics,UKC,AKC"
s-columntypes="3,202,3,3,202,202,202,135,3,3,202,202,135,203,202,202,202,202,202,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="7" b-makeform="FALSE" s-recordsource="tblDOG"
s-displaycolumns="ID,callname,AKC" s-criteria="{ID} EQ {ID} +" s-order
s-sql="SELECT * FROM tblDOG WHERE (ID = ::ID:
" b-procedure="FALSE"
clientside suggestedext="asp" s-defaultfields="ID=" s-norecordsfound="No
records returned." i-maxrecords="256" 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"><font color="#000000">This is the
start of a Database Results region. The region will not work unless the page
has a file extension of ".asp". The page must be fetched from a web server
with a web browser to display correctly; the current web is stored on your
local disk or network.</font></td></tr></table>" 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="SELECT * FROM tblDOG WHERE (ID = ::ID:"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue="
fp_sColTypes="&ID=3&name=202&sireID=3&damID=3&PreTit=202&SuffTit=202&callname=202&DOB=135&genID=3&ColorID=3&Owner=202&Breeder=202&DOD=135&website=203&Hips=202&Eyes=202&elbows=202&CNM=202&Honorifics=202&UKC=202&AKC=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14659" --><form
METHOD="POST" action="fp_update">
<!--webbot bot="PurpleText" preview="Set this form's properties so it
submits user input to the appropriate page." --><table BORDER="0">
<tr>
<td><b>callname:</b></td>
<td>
<input TYPE="TEXT" NAME="callname" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"callname")%>"></td>
</tr>
<tr>
<td><b>AKC:</b></td>
<td>
<input TYPE="TEXT" NAME="AKC" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"AKC")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="submit" NAME="fp_submit" value="update"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
</form>
<hr>
<!--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"><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="56926"
--></body></html>
I've
database where people can add, update, & edit dog information. I have
sucessfully been able to get DRW to add dog, view, search for dogs, but I
can't get it to update or edit information on dogs already in the database.
I got it to work one time, but can't remember what I did & now it's not
working again. Please help. I've looked everywhere to find a way to do this
but there's not really any answers.
I want it in an .asp page. I am starting simple with for instance the
callname & akc number, once I figure it out I can add the others.
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,name,sireID,damID,PreTit,SuffTit,callname,DOB,genID,ColorID,Owner,Breeder,DOD,website,Hips,Eyes,elbows,CNM,Honorifics,UKC,AKC"
s-columntypes="3,202,3,3,202,202,202,135,3,3,202,202,135,203,202,202,202,202,202,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="7" b-makeform="FALSE" s-recordsource="tblDOG"
s-displaycolumns="ID,callname,AKC" s-criteria="{ID} EQ {ID} +" s-order
s-sql="SELECT * FROM tblDOG WHERE (ID = ::ID:
" b-procedure="FALSE"clientside suggestedext="asp" s-defaultfields="ID=" s-norecordsfound="No
records returned." i-maxrecords="256" 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"><font color="#000000">This is the
start of a Database Results region. The region will not work unless the page
has a file extension of ".asp". The page must be fetched from a web server
with a web browser to display correctly; the current web is stored on your
local disk or network.</font></td></tr></table>" 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="SELECT * FROM tblDOG WHERE (ID = ::ID:
"fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue="
fp_sColTypes="&ID=3&name=202&sireID=3&damID=3&PreTit=202&SuffTit=202&callname=202&DOB=135&genID=3&ColorID=3&Owner=202&Breeder=202&DOD=135&website=203&Hips=202&Eyes=202&elbows=202&CNM=202&Honorifics=202&UKC=202&AKC=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14659" --><form
METHOD="POST" action="fp_update">
<!--webbot bot="PurpleText" preview="Set this form's properties so it
submits user input to the appropriate page." --><table BORDER="0">
<tr>
<td><b>callname:</b></td>
<td>
<input TYPE="TEXT" NAME="callname" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"callname")%>"></td>
</tr>
<tr>
<td><b>AKC:</b></td>
<td>
<input TYPE="TEXT" NAME="AKC" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"AKC")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="submit" NAME="fp_submit" value="update"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
</form>
<hr>
<!--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"><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="56926"
--></body></html>
I've