editing database with frontpage


H

Hlarkin

I have a simple database in which I want people to view, submit, edit, &
hyperlink to different dogs, etc.

Well I can get everything to work fine with Database Results wizard, except
to update/edit the database. I got it work one time, but can't get it work
again.

I would rather use DRW & asp then using the interface wizard.

I can get all the info to show, just not update or edit...any help would be
greatly appreciated


<!--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="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 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=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14531" --><form
METHOD="POST" action="fp_upate">
<!--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 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_update" 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>
 
Ad

Advertisements

S

Stefan B Rusynko

If you are going to stick w/ wizards you need the DBIW, Not the DBRW
See http://spiderwebwoman.com/resources/diwtipsandtricks.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have a simple database in which I want people to view, submit, edit, &
| hyperlink to different dogs, etc.
|
| Well I can get everything to work fine with Database Results wizard, except
| to update/edit the database. I got it work one time, but can't get it work
| again.
|
| I would rather use DRW & asp then using the interface wizard.
|
| I can get all the info to show, just not update or edit...any help would be
| greatly appreciated
|
|
| <!--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="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 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=2
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="14531" --><form
| METHOD="POST" action="fp_upate">
| <!--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 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_update" 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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top