editing database with frontpage

Hlarkin · Feb 23, 2008

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
-->
<% 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
%>

<form
METHOD="POST" action="fp_upate">
<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>

</body></html>

Stefan B Rusynko · Feb 23, 2008

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
| -->
| <% 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:

editing database with results wizard	1	Feb 23, 2008
updating error	1	Feb 24, 2008
I am trying to understand this code...	3	Jul 26, 2008
Unable to edit certain records in the database	6	Mar 18, 2005
Help with this calculation!!!	17	Oct 19, 2006
UPDATE database problems	10	Aug 13, 2004
Question to Data Base Results Wizard Ouput	1	Jul 21, 2005
Drop down box query	2	Dec 9, 2004

editing database with frontpage

Hlarkin

Stefan B Rusynko

Ask a Question

Similar Threads