FP Database help needed...

F

Frank

for years the attached ASP forms have been working fine.
Last week the update to the database will not take - no changes made/posted.
My hosting service is useless and claims the problem is mine and has
given little to no real help.
Just to be sure (for a while) the target database schedule.mdb has
permissions set to Owner, Group and All set to R/W/E.

Update3.asp is called via a hyperlink in a DBR with one Parameter - a
unique "record number".
Update3.asp displays the correct record.
On POST, updatef.asp is called to do the actual DB update - nothing
happens, no error message, nothing.

Appreciate it if you can give me some help as there are about 80 Users
who hit this file all the time and I am at a loss on the cause.
Frank

<html>

<head>
<title></title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

<meta name="Microsoft Border" content="none">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
</head>

<body background="images/CLOUDSBKG.jpg">

<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="schedule" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="FALSE" b-listseparator="FALSE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE schedule SET xdate='::xdate::',dispatcher='::dispatcher::',phone='::phone::',amcrew='::amcrew::',pmcrew='::pmcrew::',crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow='::pmtow::',instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::' WHERE (xrecnbr=::xrecnbr::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="xdate=&amp;amp;dispatcher=&amp;amp;phone=&amp;amp;amcrew=&amp;amp;pmcrew=&amp;amp;crew3=&amp;amp;crew4=&amp;amp;amtow=&amp;amp;pmtow=&amp;amp;instructor=&amp;amp;ipilot=&amp;amp;instruct2=&amp;amp;xrecnbr=" 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="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" 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="UPDATE schedule SET xdate='::xdate::',dispatcher='::dispatcher::',phone='::phone::',amcrew='::amcrew::',pmcrew='::pmcrew::',crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow='::pmtow::',instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::' WHERE (xrecnbr=::xrecnbr::)"
fp_sDefault="xdate=&dispatcher=&phone=&amcrew=&pmcrew=&crew3=&crew4=&amtow=&pmtow=&instructor=&ipilot=&instruct2=&xrecnbr="
fp_sNoRecords="No records returned."
fp_sDataConn="schedule"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
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 --><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --><p>
<br>
&nbsp;</p>
<p>&nbsp;</p>
<%
response.redirect "sched2.asp"
%>
</body>

</html>
<p>Comment - HTML contains a Re-Direct to sched2.asp</p>
<html>

<head>
<title></title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="KEYWORDS" CONTENT="soaring, gliders, sailplane, houston soaring">

<meta name="Microsoft Border" content="none">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
</head>

<body background="images/CLOUDSBKG.jpg">

<p><br>
<b><font size="4">Please do not use this page yet.... having a problem... Frank<br>
</font>(Changes are NOT posted to the database)</b></p>

<!--webbot bot="DatabaseRegionStart" s-columnnames="xdate,DISPATCHER,PHONE,AMCREW,PMCREW,AMTOW,PMTOW,INSTRUCTOR,xupdate,xrecnbr,ipilot,instruct2,ctldate,crew3,crew4" s-columntypes="135,202,202,202,202,202,202,202,202,202,202,202,135,202,202" s-dataconnection="schedule" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="xdate" s-menuvalue="xdate" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="schedule" s-displaycolumns="xdate,DISPATCHER,PHONE,AMCREW,PMCREW,AMTOW,PMTOW,INSTRUCTOR,instruct2,ipilot,crew3,crew4" s-criteria="[xrecnbr] EQ {xrecnbr} +" s-order s-sql="SELECT * FROM schedule WHERE (xrecnbr = '::xrecnbr::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="xrecnbr=" s-norecordsfound 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="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan b-WasTableFormat="FALSE" 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 schedule WHERE (xrecnbr = '::xrecnbr::')"
fp_sDefault="xrecnbr="
fp_sNoRecords=""
fp_sDataConn="schedule"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="xdate"
fp_sMenuValue="xdate"
fp_sColTypes="&xdate=135&DISPATCHER=202&PHONE=202&AMCREW=202&PMCREW=202&AMTOW=202&PMTOW=202&INSTRUCTOR=202&xupdate=202&xrecnbr=202&ipilot=202&instruct2=202&ctldate=135&crew3=202&crew4=202&"
fp_iDisplayCols=12
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><form method="POST" action="UpdateF.asp">
<table border="0" style="border-collapse: collapse" bordercolor="#111111" width="234">
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Date</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="xdate" size="15" value="<%=FP_FieldVal(fp_rs,"xdate")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Dispatcher</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="dispatcher" size="15" value="<%=FP_FieldVal(fp_rs,"dispatcher")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Phone</font></td>
<td width="126">
<p>
<font face="Verdana">
<input name="phone" size="15" value="<%=FP_FieldVal(fp_rs,"phone")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Crew 1</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="amcrew" size="15" value="<%=FP_FieldVal(fp_rs,"amcrew")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Crew 2 </font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="pmcrew" size="15" value="<%=FP_FieldVal(fp_rs,"pmcrew")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Crew 3</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="crew3" size="15" value="<%=FP_FieldVal(fp_rs,"crew3")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Crew 4</font></td>
<td width="126">
<font face="Verdana">
<input name="crew4" size="15" value="<%=FP_FieldVal(fp_rs,"crew4")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">AM Tow</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="amtow" size="15" value="<%=FP_FieldVal(fp_rs,"amtow")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">PM Tow</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="pmtow" size="15" value="<%=FP_FieldVal(fp_rs,"pmtow")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Instructor I</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="instructor" size="15" value="<%=FP_FieldVal(fp_rs,"instructor")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Winch Op</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="instruct2" size="15" value="<%=FP_FieldVal(fp_rs,"instruct2")%>" style="float: right"></font></td>
</tr>
<tr>
<td width="104" align="right"><font face="Verdana" size="2">Intro Pilot</font></td>
<td width="126">
<p align="center">
<font face="Verdana">
<input name="ipilot" size="15" value="<%=FP_FieldVal(fp_rs,"ipilot")%>" style="float: right"></font></td>
</tr>
</table>
<p align="center"><input type="submit" value="Update" name="Update1">&nbsp;&nbsp;&nbsp;
<font face="Verdana" size="2"><a href="sched2.asp">Return to the Schedule</a></font></p>
<input type="hidden" name="xrecnbr" value="'<%=FP_FieldHTML(fp_rs,"xrecnbr")%>'">
</form>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --></body></html>
 
S

sudhir

Hi Frank,

Since,you have not posted the version of FrontPage version but you could try
the following as there is no error message in the page for the asp,make sure
that the following is true:

1)make sure that the ASP is working fine.

2)Go to Setting in IE and go to advanced settings and unckeck "show freindly
error messages" under browsing.

3)once you are done with that open the frontpage and go to the "_fpclass"
folder and find the inc file called "fpdbrgn1.inc" and open this txt file and
look for the value called "fp_DEBUG = False",change this to true.

4)once this is done try to work with the same page and look for the exact
error message that IE report and you could use the support.microsoft.com for
more information.

Regards
sudhir
 
F

Frank

FP 2002 SP3 is being used.
Finally saw the error message KB Article 817029 has all the details.
Seems that I have to rebuild "the world" using ASP.NET 'cuz the webbot
has empty or missing s-columnnames or s-columntypes attributes.

Mycode has all the DB columns accounted for.
What are s-columntypes attributes? (can't seem to find a reference)
IF a field is empty is there a way to set a default value?
 
F

Frank

FP 2002 SP3 is being used.
Finally saw the error message KB Article 817029 has all the details.
Seems that I have to rebuild "the world" using ASP.NET 'cuz the webbot
has empty or missing s-columnnames or s-columntypes attributes.

Mycode has all the DB columns accounted for.
What are s-columntypes attributes? (can't seem to find a reference)
IF a field is empty is there a way to set a default value?
 
F

Frank

Ok, now I see the solution -- and it is going to cost me about $200 :-(
My original DBR code has no values for s-columntypes, etc.
To do 817029 either option 1 or 2 --- I have to upgrade to XP Pro
(currently using XP Home) to get the DBR ASP.NET options invoked.

Creating a new page under option 1 will be easy as the DBR is only a SQL
UPDATE schedule SET ......

Still confused why this page has worked for years and now decides to
crater...

thanks,
Frank
 
T

Thomas A. Rowe

You should be able to work directly on the live/remote server if the server has the FP extensions,
then you will not have to upgrade, specifically for the that reason.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 

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

Similar Threads

I am trying to understand this code... 3
@ my wits end 1
ASP.NET and FP 2003.... Continued 10
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
any ideas why I can update one table in my database but not the other? 2
Database Update Buttons 8
Problem with form validation 1
two tables in the same row 6

Top