|
emoss2 -> RE: DRW Submission forms (11/3/2003 13:18:41)
|
I added the <%=fp_sQuery%> code to the body of the update.asp page (below the SQL), but when I run the page by clicking the "OK" button on the edit.asp page, I still see the "Record updated inTable" message, and do not see any SQL generated that I can review. Exactly what do I need to do to see the SQL ?
Here's the code from the update.asp page. I do not see any obvious errors within.
Ed
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>tblReportData -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="TBIR" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="UPDATE tblReportData SET RptDate = #::RptDate::# , Company = '::Company::' , Symbol = '::Symbol::' , Sector = '::Sector::' , Industry = '::Industry::' , Exchange = '::Exchange::' , BValue = '::BValue::' , CPrice = ::CPrice:: , TBIRrating = '::TBIRrating::' , CCapsule = '::CCapsule::' , Comp = '::Comp::' , ShareItems = '::ShareItems::' , own = '::own::' , dands = '::dands::' , fsum = '::fsum::' , Income = '::Income::' , Hrev = '::Hrev::' , Hearn = '::Hearn::' , Headlines = '::Headlines::' , earnper = '::earnper::' , fyear = '::fyear::' , cbrok = '::cbrok::' , cbrok1 = '::cbrok1::' , cbrok2 = '::cbrok2::' , cbrok3 = '::cbrok3::' , cbrok4 = '::cbrok4::' , tbirshort = '::tbirshort::' , tbirlong = '::tbirlong::' , tbirstrat = '::tibrstrat::' , wssynop = '::wssynop::' WHERE (RptID = ::RptID::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="RptDate=&Company=&Symbol=&Sector=&Industry=&Exchange=&BValue=&CPrice=&TBIRrating=&CCapsule=&Comp=&ShareItems=&own=&dands=&fsum=&Income=&Hrev=&Hearn=&Headlines=&earnper=&fyear=&cbrok=&cbrok1=&cbrok2=&cbrok3=&cbrok4=&tbirshort=&tbirlong=&tibrstrat=&wssynop=&RptID=" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" 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 tblReportData SET RptDate = #::RptDate::# , Company = '::Company::' , Symbol = '::Symbol::' , Sector = '::Sector::' , Industry = '::Industry::' , Exchange = '::Exchange::' , BValue = '::BValue::' , CPrice = ::CPrice:: , TBIRrating = '::TBIRrating::' , CCapsule = '::CCapsule::' , Comp = '::Comp::' , ShareItems = '::ShareItems::' , own = '::own::' , dands = '::dands::' , fsum = '::fsum::' , Income = '::Income::' , Hrev = '::Hrev::' , Hearn = '::Hearn::' , Headlines = '::Headlines::' , earnper = '::earnper::' , fyear = '::fyear::' , cbrok = '::cbrok::' , cbrok1 = '::cbrok1::' , cbrok2 = '::cbrok2::' , cbrok3 = '::cbrok3::' , cbrok4 = '::cbrok4::' , tbirshort = '::tbirshort::' , tbirlong = '::tbirlong::' , tbirstrat = '::tibrstrat::' , wssynop = '::wssynop::' WHERE (RptID = ::RptID::)"
fp_sDefault="RptDate=&Company=&Symbol=&Sector=&Industry=&Exchange=&BValue=&CPrice=&TBIRrating=&CCapsule=&Comp=&ShareItems=&own=&dands=&fsum=&Income=&Hrev=&Hearn=&Headlines=&earnper=&fyear=&cbrok=&cbrok1=&cbrok2=&cbrok3=&cbrok4=&tbirshort=&tbirlong=&tibrstrat=&wssynop=&RptID="
fp_sNoRecords="Record updated in table."
fp_sDataConn="TBIR"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="35815" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
<%=fp_sQuery%>
</body>
</html>
|
|
|
|
