A
Andy Watts
Hi,
I'm having problems updating a database - i'm bringing the data up fine in a
form but am getting in a right pickle trying to update the information.
I've tried so many combinations I'm not sure which I haven't tried. I've
also looked up many sources on the web and even bought a book (Inside Out)
and still can't find a definitive answer. I'm now also confused whether I
should have a ' round text or digits in the SQL statement, oh dear :-s.
Many thanks for your valuable time. I hope it is something obvious!
Thanks
Andy Watts
=======================
Firstly, here is the form code:
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,Product,Description,SUPPLIER,STOCK,price"
s-columntypes="3,202,202,202,5,5" s-dataconnection="Database1"
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="oldstock"
s-displaycolumns="ID,Product,Description,SUPPLIER,STOCK,price"
s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM oldstock WHERE (ID
= ::ID:
" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="ID=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>"
b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3" b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes="3" b-WasTableFormat="FALSE"
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 oldstock WHERE (ID = ::ID:"
fp_sDefault="ID=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="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&Product=202&Description=202&SUPPLIER=202&STOCK=5&price=5
&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="54633" --><form
METHOD="POST" action="updatesql.asp">
<!--webbot bot="PurpleText" preview="Set this form's properties so it
submits user input to the appropriate page." --><table BORDER="0">
<tr>
<td><b>ID:</b></td>
<td>
<input TYPE="TEXT" NAME="ID" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"></td>
</tr>
<tr>
<td><b>Product:</b></td>
<td>
<input TYPE="TEXT" NAME="Product" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"Product")%>"></td>
</tr>
<tr>
<td><b>Description:</b></td>
<td>
<input TYPE="TEXT" NAME="Description" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"Description")%>"></td>
</tr>
<tr>
<td><b>SUPPLIER:</b></td>
<td>
<input TYPE="TEXT" NAME="SUPPLIER" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"SUPPLIER")%>"></td>
</tr>
<tr>
<td><b>STOCK:</b></td>
<td>
<input TYPE="TEXT" NAME="STOCK" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"STOCK")%>"></td>
</tr>
<tr>
<td><b>price:</b></td>
<td>
<input TYPE="TEXT" NAME="price" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"price")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><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" -->
============================================
Secondly, here is the updatesql.asp (updating the database) page:
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes
s-dataconnection="Database1" 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 oldstock <br>SET
Product=':roduct::', Description=':escription::',
SUPPLIER='::SUPPLIER::', STOCK=::STOCK::, price=:rice::<br>WHERE
ID=::ID::" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Product=&Description=&SUPPLIER=&STOCK=&pric
e=&ID=" s-norecordsfound="Record updated" i-maxrecords="256"
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"
width="100%"><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>"
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 oldstock SET Product=':roduct::',
Description=':escription::', SUPPLIER='::SUPPLIER::', STOCK=::STOCK::,
price=:rice:: WHERE ID=::ID::"
fp_sDefault="Product=&Description=&SUPPLIER=&STOCK=&price=&ID="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">Record
updated</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
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="36996" --><!--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"
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="56926" --></tbody>
I'm having problems updating a database - i'm bringing the data up fine in a
form but am getting in a right pickle trying to update the information.
I've tried so many combinations I'm not sure which I haven't tried. I've
also looked up many sources on the web and even bought a book (Inside Out)
and still can't find a definitive answer. I'm now also confused whether I
should have a ' round text or digits in the SQL statement, oh dear :-s.
Many thanks for your valuable time. I hope it is something obvious!
Thanks
Andy Watts
=======================
Firstly, here is the form code:
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,Product,Description,SUPPLIER,STOCK,price"
s-columntypes="3,202,202,202,5,5" s-dataconnection="Database1"
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="oldstock"
s-displaycolumns="ID,Product,Description,SUPPLIER,STOCK,price"
s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM oldstock WHERE (ID
= ::ID:
" b-procedure="FALSE" clientside suggestedext="asp"s-defaultfields="ID=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>"
b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3" b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes="3" b-WasTableFormat="FALSE"
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 oldstock WHERE (ID = ::ID:
"fp_sDefault="ID=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="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&Product=202&Description=202&SUPPLIER=202&STOCK=5&price=5
&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="54633" --><form
METHOD="POST" action="updatesql.asp">
<!--webbot bot="PurpleText" preview="Set this form's properties so it
submits user input to the appropriate page." --><table BORDER="0">
<tr>
<td><b>ID:</b></td>
<td>
<input TYPE="TEXT" NAME="ID" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"></td>
</tr>
<tr>
<td><b>Product:</b></td>
<td>
<input TYPE="TEXT" NAME="Product" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"Product")%>"></td>
</tr>
<tr>
<td><b>Description:</b></td>
<td>
<input TYPE="TEXT" NAME="Description" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"Description")%>"></td>
</tr>
<tr>
<td><b>SUPPLIER:</b></td>
<td>
<input TYPE="TEXT" NAME="SUPPLIER" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"SUPPLIER")%>"></td>
</tr>
<tr>
<td><b>STOCK:</b></td>
<td>
<input TYPE="TEXT" NAME="STOCK" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"STOCK")%>"></td>
</tr>
<tr>
<td><b>price:</b></td>
<td>
<input TYPE="TEXT" NAME="price" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"price")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><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" -->
============================================
Secondly, here is the updatesql.asp (updating the database) page:
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes
s-dataconnection="Database1" 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 oldstock <br>SET
Product=':
roduct::', Description=':escription::',SUPPLIER='::SUPPLIER::', STOCK=::STOCK::, price=:
rice::<br>WHEREID=::ID::" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Product=&Description=&SUPPLIER=&STOCK=&pric
e=&ID=" s-norecordsfound="Record updated" i-maxrecords="256"
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"
width="100%"><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>"
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 oldstock SET Product=':
roduct::',Description=':
escription::', SUPPLIER='::SUPPLIER::', STOCK=::STOCK::,price=:
rice:: WHERE ID=::ID::"fp_sDefault="Product=&Description=&SUPPLIER=&STOCK=&price=&ID="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">Record
updated</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
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="36996" --><!--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"
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="56926" --></tbody>