Date Last Updated (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

steveearlefan -> Date Last Updated (4/1/2005 15:29:53)

I like my results page to display the last date the record was updated. I have a field named UpdatedOn. Whenever I use Access to show this field as a date/time and add a default value I still get the frontpage error about form fields are empty. No records are empty! What can i do??



rdouglass -> RE: Date Last Updated (4/1/2005 15:32:39)

Can you post your SQL code you're using?

Also, if you're trying to write back to the DB, be sure your date value is delimited by # and not ' as in:

UPDATE myTable SET UpdatedOn = #" & Date() & "#...

That any help?



dzirkelb1 -> RE: Date Last Updated (4/1/2005 15:40:33)

Post your form code too please



steveearlefan -> RE: Date Last Updated (4/1/2005 16:16:22)

here's the UPDATE page code. I tried several different things in the UpdatedOn = ??????? field!!!!! 


<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>Table1 -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="none">
</head>

<body>
<!--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="loanstatus" 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 Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"()"# , AppTakenOn = '::AppTakenOn::' , RespaMailedOn = '::RespaMailedOn::' , RespaReceivedOn = '::RespaReceivedOn::' , Appraiser = '::Appraiser::' , AppraisalOrderedOn = '::AppraisalOrderedOn::' , AppraisalReceivedOn = '::AppraisalReceivedOn::' , SubmittedOn = '::SubmittedOn::' , StipsReceivedOn = '::StipsReceivedOn::' , StipsFaxedOn = '::StipsFaxedOn::' , ClearToCloseOn = '::ClearToCloseOn::' , Attorney = '::Attorney::' , TitleOrderedOn = '::TitleOrderedOn::' , TitleReceivedOn = '::TitleReceivedOn::' , InsuranceAgent = '::InsuranceAgent::' , InsOrderedOn = '::InsOrderedOn::' , InsReceivedOn = '::InsReceivedOn::' , ReadyToScheduleOn = '::ReadyToScheduleOn::' , DeniedOn = '::DeniedOn::' , WithdrawnOn = '::WithdrawnOn::' , BorrowerAddress = '::BorrowerAddress::' , BorrowerCity = '::BorrowerCity::' , BorrowerZip = '::BorrowerZip::' , BorrowerCounty = '::BorrowerCounty::' , BorrowerSocSec = '::BorrowerSocSec::' , BorrowerCreditScore = '::BorrowerCreditScore::' , OriginatorIDNumber = '::OriginatorIDNumber::' , Originator = '::Originator::' , Contact = '::Contact::' , OriginatorEmail = '::OriginatorEmail::' , ContactEmail = '::ContactEmail::' , PropertyType = '::PropertyType::' , Product = '::Product::' , Occupancy = '::Occupancy::' , AppraisedValue = '::AppraisedValue::' , LTV = '::LTV::' , LenderName = '::LenderName::' , LenderLoanNumber = '::LenderLoanNumber::' , LockedTerm = '::LockedTerm::' , DocType = '::DocType::' , Escrow = '::Escrow::' , LockedDate = '::LockedDate::' , AppraisalOrderedBy = '::AppraisalOrderedBy::' , AppraisalPaidBy = '::AppraisalPaidBy::' , AttorneyPhone = '::AttorneyPhone::' , AppraiserPhone = '::AppraiserPhone::' , InsAgentPhone = '::InsAgentPhone::' , PayoffsOrderedOn = '::PayoffsOrderedOn::' , AmountofPayoffs = '::AmountofPayoffs::' , ChecksReceivedOn = '::ChecksReceivedOn::' , Condition1 = '::Condition1::' , Condition2 = '::Condition2::' , Condition3 = '::Condition3::' , Condtion4 = '::Condtion4::' , Condition5 = '::Condition5::' , Condition6 = '::Condition6::' , Condition7 = '::Condition7::' , Condition8 = '::Condition8::' , Condition9 = '::Condition9::' , Condition10 = '::Condition10::' , Condition11 = '::Condition11::' , Condition12 = '::Condition12::' , ActiveLoan = '::ActiveLoan::' , UserName = '::UserName::' , Password = '::Password::' , ScheduleOn = '::ScheduleOn::' , Prefers = '::Prefers::' , IntCredit = '::IntCredit::' , Collect = '::Collect::' , HowMuch = '::HowMuch::' , ExpectToPay = '::ExpectToPay::' , ExpectToGet = '::ExpectToGet::' , PayingOff = '::PayingOff::' , Subordination = '::Subordination::' , ClosingConfirmed = '::ClosingConfirmed::'  WHERE (LoanNumber = ::LoanNumber::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0" 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>" --><!--#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 Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"
fp_sDefault="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="loanstatus"
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="38751" -->

<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="65064" -->
<p align="center">
<input type="button" value="Close Window" onClick="window.close()"></p>

</body>

</html>



steveearlefan -> RE: Date Last Updated (4/1/2005 16:17:08)

here's the code for the "edit" page 

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Originator's Resources</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="none">
</head>

<body>
<!--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." -->

<!--webbot bot="DatabaseRegionStart" s-columnnames="LoanNumber,Status,LastName,FirstName,BorrowerPhone,BorrowerCellEmail,LoanAmount,Purpose,LockExpiresOn,OriginalLockTerm,ClosingDateOn,InterestRate,OrigFeePercentage,OrigFeeDollarAmt,YieldSpredPremPercentage,YieldSpreadPremDollarAmt,UpdatedOn,AppTakenOn,RespaMailedOn,RespaReceivedOn,Appraiser,AppraisalOrderedOn,AppraisalReceivedOn,SubmittedOn,StipsReceivedOn,StipsFaxedOn,ClearToCloseOn,Attorney,TitleOrderedOn,TitleReceivedOn,InsuranceAgent,InsOrderedOn,InsReceivedOn,ReadyToScheduleOn,DeniedOn,WithdrawnOn,BorrowerAddress,BorrowerCity,BorrowerZip,BorrowerCounty,BorrowerSocSec,BorrowerCreditScore,OriginatorIDNumber,Originator,Contact,OriginatorEmail,ContactEmail,PropertyType,Product,Occupancy,AppraisedValue,LTV,LenderName,LenderLoanNumber,LockedTerm,DocType,Escrow,LockedDate,AppraisalOrderedBy,AppraisalPaidBy,AttorneyPhone,AppraiserPhone,InsAgentPhone,PayoffsOrderedOn,AmountofPayoffs,ChecksReceivedOn,Condition1,Condition2,Condition3,Condtion4,Condition5,Condition6,Condition7,Condition8,Condition9,Condition10,Condition11,Condition12,ActiveLoan,UserName,Password" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,203,203,203,203,203,203,203,203,203,203,203,202,202,202" s-dataconnection="loanstatus" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-ListFormat="5" b-makeform="FALSE" s-RecordSource="Table1" s-displaycolumns="LoanNumber,Status,LastName,FirstName,BorrowerPhone,BorrowerCellEmail,LoanAmount,Purpose,LockExpiresOn,OriginalLockTerm,ClosingDateOn,InterestRate,OrigFeePercentage,OrigFeeDollarAmt,YieldSpredPremPercentage,YieldSpreadPremDollarAmt,UpdatedOn,AppTakenOn,RespaMailedOn,RespaReceivedOn,Appraiser,AppraisalOrderedOn,AppraisalReceivedOn,SubmittedOn,StipsReceivedOn,StipsFaxedOn,ClearToCloseOn,Attorney,TitleOrderedOn,TitleReceivedOn,InsuranceAgent,InsOrderedOn,InsReceivedOn,ReadyToScheduleOn,DeniedOn,WithdrawnOn,BorrowerAddress,BorrowerCity,BorrowerZip,BorrowerCounty,BorrowerSocSec,BorrowerCreditScore,OriginatorIDNumber,Originator,Contact,OriginatorEmail,ContactEmail,PropertyType,Product,Occupancy,AppraisedValue,LTV,LenderName,LenderLoanNumber,LockedTerm,DocType,Escrow,LockedDate,AppraisalOrderedBy,AppraisalPaidBy,AttorneyPhone,AppraiserPhone,InsAgentPhone,PayoffsOrderedOn,AmountofPayoffs,ChecksReceivedOn,Condition1,Condition2,Condition3,Condtion4,Condition5,Condition6,Condition7,Condition8,Condition9,Condition10,Condition11,Condition12,ActiveLoan,UserName,Password" s-criteria="{LoanNumber} EQ {LoanNumber} +" s-order s-sql="SELECT * FROM Table1 WHERE LoanNumber = ::LoanNumber::" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="LoanNumber=0" s-NoRecordsFound="No records returned." 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>" --><!--#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 Table1 WHERE LoanNumber = ::LoanNumber::"
fp_sDefault="LoanNumber=0"
fp_sNoRecords="No records returned."
fp_sDataConn="loanstatus"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=81
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="46713" --> <form METHOD="POST" action="update.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
	<table BORDER=0 width="792">

<tr>
<td width="786">
	<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="454" id="AutoNumber1" height="16">
      <tr>
        <td height="16" width="454"><b>
        <font face="Arial" style="font-size: 9pt">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="LoanNumber,Status,LastName,FirstName,BorrowerPhone,BorrowerCellEmail,LoanAmount,Purpose,LockExpiresOn,OriginalLockTerm,ClosingDateOn,InterestRate,OrigFeePercentage,OrigFeeDollarAmt,YieldSpredPremPercentage,YieldSpreadPremDollarAmt,UpdatedOn,AppTakenOn,RespaMailedOn,RespaReceivedOn,Appraiser,AppraisalOrderedOn,AppraisalReceivedOn,SubmittedOn,StipsReceivedOn,StipsFaxedOn,ClearToCloseOn,Attorney,TitleOrderedOn,TitleReceivedOn,InsuranceAgent,InsOrderedOn,InsReceivedOn,ReadyToScheduleOn,DeniedOn,WithdrawnOn,BorrowerAddress,BorrowerCity,BorrowerZip,BorrowerCounty,BorrowerSocSec,BorrowerCreditScore,OriginatorIDNumber,Originator,Contact,OriginatorEmail,ContactEmail,PropertyType,Product,Occupancy,AppraisedValue,LTV,LenderName,LenderLoanNumber,LockedTerm,DocType,Escrow,LockedDate,AppraisalOrderedBy,AppraisalPaidBy,AttorneyPhone,AppraiserPhone,InsAgentPhone,PayoffsOrderedOn,AmountofPayoffs,ChecksReceivedOn,Condition1,Condition2,Condition3,Condtion4,Condition5,Condition6,Condition7,Condition8,Condition9,Condition10,Condition11,Condition12,ActiveLoan,UserName,Password" s-column="LastName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>LastName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"LastName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14417" -->,
      <!--webbot bot="DatabaseResultColumn" s-columnnames="LoanNumber,Status,LastName,FirstName,BorrowerPhone,BorrowerCellEmail,LoanAmount,Purpose,LockExpiresOn,OriginalLockTerm,ClosingDateOn,InterestRate,OrigFeePercentage,OrigFeeDollarAmt,YieldSpredPremPercentage,YieldSpreadPremDollarAmt,UpdatedOn,AppTakenOn,RespaMailedOn,RespaReceivedOn,Appraiser,AppraisalOrderedOn,AppraisalReceivedOn,SubmittedOn,StipsReceivedOn,StipsFaxedOn,ClearToCloseOn,Attorney,TitleOrderedOn,TitleReceivedOn,InsuranceAgent,InsOrderedOn,InsReceivedOn,ReadyToScheduleOn,DeniedOn,WithdrawnOn,BorrowerAddress,BorrowerCity,BorrowerZip,BorrowerCounty,BorrowerSocSec,BorrowerCreditScore,OriginatorIDNumber,Originator,Contact,OriginatorEmail,ContactEmail,PropertyType,Product,Occupancy,AppraisedValue,LTV,LenderName,LenderLoanNumber,LockedTerm,DocType,Escrow,LockedDate,AppraisalOrderedBy,AppraisalPaidBy,AttorneyPhone,AppraiserPhone,InsAgentPhone,PayoffsOrderedOn,AmountofPayoffs,ChecksReceivedOn,Condition1,Condition2,Condition3,Condtion4,Condition5,Condition6,Condition7,Condition8,Condition9,Condition10,Condition11,Condition12,ActiveLoan,UserName,Password" s-column="FirstName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>FirstName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"FirstName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18712" --> </font>
        </b>
        </td>
      </tr>
    </table>
    <table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#346699" width="350" id="AutoNumber2">
      <tr>
        <td colspan="4" height="28" width="750"><b>
        <font color="#003366" face="Arial" style="font-size: 8pt">Please complete this form to 
        show loan as approved</font></b></td>
      </tr>
      <tr>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Respa Mailed On</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="RespaMailedOn" s-data-type="String" b-value-required="TRUE" --><input name="RespaMailedOn" size="11" value="<%=FP_FieldHTML(fp_rs,"RespaMailedOn")%>"></font></td>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Lender</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="LenderName" s-data-type="String" b-value-required="TRUE" i-maximum-length="50" --><input name="LenderName" size="24" value="<%=FP_FieldHTML(fp_rs,"LenderName")%>" maxlength="50"></font></td>
      </tr>
      <tr>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Middle Credit 
        Score</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="BorrowerCreditScore" s-data-type="String" b-value-required="TRUE" i-maximum-length="50" --><input name="BorrowerCreditScore" size="7" value="<%=FP_FieldHTML(fp_rs,"BorrowerCreditScore")%>" maxlength="50"></font></td>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Loan Purpose</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Purpose">
        <option>Please Choose</option>
        <option>Purchase</option>
        <option>Rate Term Refi</option>
        <option>Cash Out Refi</option>
        <option>2nd Mortgage</option>
        </select></font></td>
      </tr>
      <tr>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Property Type</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="PropertyType">
        <option>Please Choose</option>
        <option>HOUSE</option>
        <option>MANUF HOME</option>
        <option>CONDO</option>
        </select></font></td>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Occupancy</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Occupancy">
        <option>Please Choose</option>
        <option>Owner</option>
        <option>Second Home</option>
        <option>Investment</option>
        </select></font></td>
      </tr>
      <tr>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Loan Amount</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="LoanAmount" s-data-type="String" b-value-required="TRUE" i-maximum-length="19" --><input name="LoanAmount" size="16" value="<%=FP_FieldHTML(fp_rs,"LoanAmount")%>" maxlength="19"></font></td>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Doc Type</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="DocType">
        <option>Please Choose</option>
        <option>Full Doc</option>
        <option>Stated Income</option>
        <option>No Doc</option>
        <option>Limited Doc</option>
        <option>No Ratio</option>
        </select></font></td>
      </tr>
      <tr>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Origination Fee 
        Percentage</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="OrigFeePercentage" s-data-type="String" b-value-required="TRUE" i-maximum-length="50" --><input name="OrigFeePercentage" size="3" value="<%=FP_FieldHTML(fp_rs,"OrigFeePercentage")%>" maxlength="50"></font></td>
        <td height="18" width="117"><font face="Arial" style="font-size: 8pt">Origination Fee 
        Dollar Amount</font></td>
        <td height="18" width="117">
        <font face="Arial" style="font-size: 8pt">
        <!--webbot bot="Validation" s-display-name="OrigFeeDollarAmt" s-data-type="String" b-value-required="TRUE" i-maximum-length="19" --><input name="OrigFeeDollarAmt" size="10" value="<%=FP_FieldHTML(fp_rs,"OrigFeeDollarAmt")%>" maxlength="19"></font></td>
      </tr>
      <tr>
        <td height="18" width="750" colspan="4"><font face="Arial">
        <font style="font-size: 8pt">Does the borrower want an escrow?  </font>
        <span style="font-size: 8pt">
        <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Escrow">
        <option>Please Choose</option>
        <option>Yes</option>
        <option>No</option>
        </select></span></font></td>
      </tr>
      </table>
    </td>
</tr>

	
	<tr>
	<td width="786">
    <p align="left"><input type="submit" value="   SUBMIT    "></td>
	</tr>

	</table>
	<input type="hidden" name="BorrowerPhone" value="<%=FP_FieldHTML(fp_rs,"BorrowerPhone")%>">
	<input type="hidden" name="BorrowerCellEmail" value="<%=FP_FieldHTML(fp_rs,"BorrowerCellEmail")%>">
	<input type="hidden" name="BorrowerSocSec" value="<%=FP_FieldHTML(fp_rs,"BorrowerSocSec")%>">
	<input type="hidden" name="BorrowerAddress" value="<%=FP_FieldHTML(fp_rs,"BorrowerAddress")%>">
	<input type="hidden" name="BorrowerCity" value="<%=FP_FieldHTML(fp_rs,"BorrowerCity")%>">
	<input type="hidden" name="BorrowerZip" value="<%=FP_FieldHTML(fp_rs,"BorrowerZip")%>">
	<input type="hidden" name="BorrowerCounty" value="<%=FP_FieldHTML(fp_rs,"BorrowerCounty")%>">
	<input type="hidden" name="LastName" value="<%=FP_FieldHTML(fp_rs,"LastName")%>">
	<input type="hidden" name="FirstName" value="<%=FP_FieldHTML(fp_rs,"FirstName")%>">
	<input type="hidden" name="AppTakenOn" value="<%=FP_FieldHTML(fp_rs,"AppTakenOn")%>">
	<input type="hidden" name="UserName" value="<%=FP_FieldHTML(fp_rs,"UserName")%>">
	<input type="hidden" name="Password" value="<%=FP_FieldHTML(fp_rs,"Password")%>">
	<input type="hidden" name="LoanNumber" value="<%=FP_FieldHTML(fp_rs,"LoanNumber")%>">
	<input type="hidden" name="Status" value="Approved">
	<input type="hidden" name="ActiveLoan" value="Yes">
	<input type="hidden" name="Originator" value="<%=FP_FieldHTML(fp_rs,"Originator")%>">
	<input type="hidden" name="OriginatorIDNumber" value="<%=FP_FieldHTML(fp_rs,"OriginatorIDNumber")%>">
	<input type="hidden" name="OriginatorEmail" value="<%=FP_FieldHTML(fp_rs,"OriginatorEmail")%>">
    <input type="hidden" name="UpdatedOn" value="()">

	
	


</form>

<!--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="65064" -->

</body>

</html>



rdouglass -> RE: Date Last Updated (4/1/2005 16:25:01)

If you want the date that the record was updated automatically, you should only need to make the change on your update page: 
fp_sQry="UPDATE Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"& Date() & "#"


As long as the UpdatedOn is a Date/Time field in Access, that should work. That any help?



dzirkelb1 -> RE: Date Last Updated (4/1/2005 16:31:14)

You also shouldn't need the hidden field if you do it all on the sql query...you could remove

<input type="hidden" name="UpdatedOn" value="()">



steveearlefan -> RE: Date Last Updated (4/8/2005 16:10:15)

Here's the error I get when I have Acces as a date/time field and the only change I make is to the Update Page as instructed in the previous post.

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '#'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.



dzirkelb1 -> RE: Date Last Updated (4/8/2005 16:15:26)

Post the code please, sounds like a # is missing or added



steveearlefan -> RE: Date Last Updated (4/8/2005 16:23:44)

Acutally, I didn't realize before but I can not change that line of the update code. It's in red.
Here's what it says now: 

<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>Table1 -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="none">
</head>

<body>
<!--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="loanstatus" 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 Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , AppTakenOn = '::AppTakenOn::' , RespaMailedOn = '::RespaMailedOn::' , RespaReceivedOn = '::RespaReceivedOn::' , Appraiser = '::Appraiser::' , AppraisalOrderedOn = '::AppraisalOrderedOn::' , AppraisalReceivedOn = '::AppraisalReceivedOn::' , SubmittedOn = '::SubmittedOn::' , StipsReceivedOn = '::StipsReceivedOn::' , StipsFaxedOn = '::StipsFaxedOn::' , ClearToCloseOn = '::ClearToCloseOn::' , Attorney = '::Attorney::' , TitleOrderedOn = '::TitleOrderedOn::' , TitleReceivedOn = '::TitleReceivedOn::' , InsuranceAgent = '::InsuranceAgent::' , InsOrderedOn = '::InsOrderedOn::' , InsReceivedOn = '::InsReceivedOn::' , ReadyToScheduleOn = '::ReadyToScheduleOn::' , DeniedOn = '::DeniedOn::' , WithdrawnOn = '::WithdrawnOn::' , BorrowerAddress = '::BorrowerAddress::' , BorrowerCity = '::BorrowerCity::' , BorrowerZip = '::BorrowerZip::' , BorrowerCounty = '::BorrowerCounty::' , BorrowerSocSec = '::BorrowerSocSec::' , BorrowerCreditScore = '::BorrowerCreditScore::' , OriginatorIDNumber = '::OriginatorIDNumber::' , Originator = '::Originator::' , Contact = '::Contact::' , OriginatorEmail = '::OriginatorEmail::' , ContactEmail = '::ContactEmail::' , PropertyType = '::PropertyType::' , Product = '::Product::' , Occupancy = '::Occupancy::' , AppraisedValue = '::AppraisedValue::' , LTV = '::LTV::' , LenderName = '::LenderName::' , LenderLoanNumber = '::LenderLoanNumber::' , LockedTerm = '::LockedTerm::' , DocType = '::DocType::' , Escrow = '::Escrow::' , LockedDate = '::LockedDate::' , AppraisalOrderedBy = '::AppraisalOrderedBy::' , AppraisalPaidBy = '::AppraisalPaidBy::' , AttorneyPhone = '::AttorneyPhone::' , AppraiserPhone = '::AppraiserPhone::' , InsAgentPhone = '::InsAgentPhone::' , PayoffsOrderedOn = '::PayoffsOrderedOn::' , AmountofPayoffs = '::AmountofPayoffs::' , ChecksReceivedOn = '::ChecksReceivedOn::' , Condition1 = '::Condition1::' , Condition2 = '::Condition2::' , Condition3 = '::Condition3::' , Condtion4 = '::Condtion4::' , Condition5 = '::Condition5::' , Condition6 = '::Condition6::' , Condition7 = '::Condition7::' , Condition8 = '::Condition8::' , Condition9 = '::Condition9::' , Condition10 = '::Condition10::' , Condition11 = '::Condition11::' , Condition12 = '::Condition12::' , ActiveLoan = '::ActiveLoan::' , UserName = '::UserName::' , Password = '::Password::' , ScheduleOn = '::ScheduleOn::' , Prefers = '::Prefers::' , IntCredit = '::IntCredit::' , Collect = '::Collect::' , HowMuch = '::HowMuch::' , ExpectToPay = '::ExpectToPay::' , ExpectToGet = '::ExpectToGet::' , PayingOff = '::PayingOff::' , Subordination = '::Subordination::' , ClosingConfirmed = '::ClosingConfirmed::'  WHERE (LoanNumber = ::LoanNumber::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0" 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>" --><!--#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 Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , AppTakenOn = '::AppTakenOn::' , RespaMailedOn = '::RespaMailedOn::' , RespaReceivedOn = '::RespaReceivedOn::' , Appraiser = '::Appraiser::' , AppraisalOrderedOn = '::AppraisalOrderedOn::' , AppraisalReceivedOn = '::AppraisalReceivedOn::' , SubmittedOn = '::SubmittedOn::' , StipsReceivedOn = '::StipsReceivedOn::' , StipsFaxedOn = '::StipsFaxedOn::' , ClearToCloseOn = '::ClearToCloseOn::' , Attorney = '::Attorney::' , TitleOrderedOn = '::TitleOrderedOn::' , TitleReceivedOn = '::TitleReceivedOn::' , InsuranceAgent = '::InsuranceAgent::' , InsOrderedOn = '::InsOrderedOn::' , InsReceivedOn = '::InsReceivedOn::' , ReadyToScheduleOn = '::ReadyToScheduleOn::' , DeniedOn = '::DeniedOn::' , WithdrawnOn = '::WithdrawnOn::' , BorrowerAddress = '::BorrowerAddress::' , BorrowerCity = '::BorrowerCity::' , BorrowerZip = '::BorrowerZip::' , BorrowerCounty = '::BorrowerCounty::' , BorrowerSocSec = '::BorrowerSocSec::' , BorrowerCreditScore = '::BorrowerCreditScore::' , OriginatorIDNumber = '::OriginatorIDNumber::' , Originator = '::Originator::' , Contact = '::Contact::' , OriginatorEmail = '::OriginatorEmail::' , ContactEmail = '::ContactEmail::' , PropertyType = '::PropertyType::' , Product = '::Product::' , Occupancy = '::Occupancy::' , AppraisedValue = '::AppraisedValue::' , LTV = '::LTV::' , LenderName = '::LenderName::' , LenderLoanNumber = '::LenderLoanNumber::' , LockedTerm = '::LockedTerm::' , DocType = '::DocType::' , Escrow = '::Escrow::' , LockedDate = '::LockedDate::' , AppraisalOrderedBy = '::AppraisalOrderedBy::' , AppraisalPaidBy = '::AppraisalPaidBy::' , AttorneyPhone = '::AttorneyPhone::' , AppraiserPhone = '::AppraiserPhone::' , InsAgentPhone = '::InsAgentPhone::' , PayoffsOrderedOn = '::PayoffsOrderedOn::' , AmountofPayoffs = '::AmountofPayoffs::' , ChecksReceivedOn = '::ChecksReceivedOn::' , Condition1 = '::Condition1::' , Condition2 = '::Condition2::' , Condition3 = '::Condition3::' , Condtion4 = '::Condtion4::' , Condition5 = '::Condition5::' , Condition6 = '::Condition6::' , Condition7 = '::Condition7::' , Condition8 = '::Condition8::' , Condition9 = '::Condition9::' , Condition10 = '::Condition10::' , Condition11 = '::Condition11::' , Condition12 = '::Condition12::' , ActiveLoan = '::ActiveLoan::' , UserName = '::UserName::' , Password = '::Password::' , ScheduleOn = '::ScheduleOn::' , Prefers = '::Prefers::' , IntCredit = '::IntCredit::' , Collect = '::Collect::' , HowMuch = '::HowMuch::' , ExpectToPay = '::ExpectToPay::' , ExpectToGet = '::ExpectToGet::' , PayingOff = '::PayingOff::' , Subordination = '::Subordination::' , ClosingConfirmed = '::ClosingConfirmed::'  WHERE (LoanNumber = ::LoanNumber::)"
fp_sDefault="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="loanstatus"
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="49559" -->

<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" -->
<p align="center">
<input type="button" value="Close Window" onClick="window.close()"></p>

</body>

</html>



dzirkelb1 -> RE: Date Last Updated (4/8/2005 16:30:04)

To edit the red portion, put the code on a diet...refer to http://www.outfront.net/spooky/adv_drw_diet.htm



steveearlefan -> RE: Date Last Updated (4/8/2005 17:25:55)

OMG! i tried that and did the spooky diet on my update page. When I tested it --it replaced all 2,000 of my records with the same new record!!!!!!! I did have a backup of my database so I didn't lose anything after all. here's what my after spooky update page looked like: 



<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>Table1 -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="none">
</head>

<body>

<!--#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 Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"& Date() & "#"
fp_sDefault="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="loanstatus"
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"-->



<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" -->
<p align="center">
<input type="button" value="Close Window" onClick="window.close()"></p>

</body>

</html>



BeTheBall -> RE: Date Last Updated (4/8/2005 17:39:38)

quote:

ORIGINAL: steveearlefan

OMG! i tried that and did the spooky diet on my update page. When I tested it --it replaced all 2,000 of my records with the same new record!!!!!!!


Of course it did. You have no WHERE clause telling the SQL which record(s) to update.



steveearlefan -> RE: Date Last Updated (4/11/2005 1:08:26)

Can you please tell me which line is missing. I looked back at the frontpage generated update page and I don't see the word WHERE anywhere. The before and after code is posted in this thread. I thought I followed directions perfectly with the spooky diet but I guess I didn't. I have tried all weekend to get this rigth but I'm just not getting it!!!!!!!



dzirkelb1 -> RE: Date Last Updated (4/11/2005 10:13:30)

fp_sQry="UPDATE Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"& Date() & "#"


That line of code has no WHERE clause, your sql statement, basically as is it tells to update the whole database with those criteria. you need a where clause to tell the database which individual record to update. Usually its a unique number like the primary key.



BeTheBall -> RE: Date Last Updated (4/11/2005 10:28:04)

From what I can tell, you never added a WHERE clause. The diet had nothing to do with it. Anyway, try changing your SQL to:

fp_sQry="UPDATE Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , UpdatedOn = #"& Date() & "# WHERE LoanNumber = ::LoanNumber::"



steveearlefan -> RE: Date Last Updated (4/12/2005 16:56:16)

Great! It finally works. I more small problem though. I have Access set to display the date at "general date" which includes the date and time. However, the results are only showing the date. Is this because of the sql statement or what? 


<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Table1 -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">

<!--#include file="../../../_fpclass/fpdblib.inc"-->

<%
fp_sQry="UPDATE Table1 SET Status = '::Status::' , LastName = '::LastName::' , FirstName = '::FirstName::' , BorrowerPhone = '::BorrowerPhone::' , BorrowerCellEmail = '::BorrowerCellEmail::' , LoanAmount = '::LoanAmount::' , Purpose = '::Purpose::' , LockExpiresOn = '::LockExpiresOn::' , OriginalLockTerm = '::OriginalLockTerm::' , ClosingDateOn = '::ClosingDateOn::' , InterestRate = '::InterestRate::' , OrigFeePercentage = '::OrigFeePercentage::' , OrigFeeDollarAmt = '::OrigFeeDollarAmt::' , YieldSpredPremPercentage = '::YieldSpredPremPercentage::' , YieldSpreadPremDollarAmt = '::YieldSpreadPremDollarAmt::' , AppTakenOn = '::AppTakenOn::' , RespaMailedOn = '::RespaMailedOn::' , RespaReceivedOn = '::RespaReceivedOn::' , Appraiser = '::Appraiser::' , AppraisalOrderedOn = '::AppraisalOrderedOn::' , AppraisalReceivedOn = '::AppraisalReceivedOn::' , SubmittedOn = '::SubmittedOn::' , StipsReceivedOn = '::StipsReceivedOn::' , StipsFaxedOn = '::StipsFaxedOn::' , ClearToCloseOn = '::ClearToCloseOn::' , Attorney = '::Attorney::' , TitleOrderedOn = '::TitleOrderedOn::' , TitleReceivedOn = '::TitleReceivedOn::' , InsuranceAgent = '::InsuranceAgent::' , InsOrderedOn = '::InsOrderedOn::' , InsReceivedOn = '::InsReceivedOn::' , ReadyToScheduleOn = '::ReadyToScheduleOn::' , DeniedOn = '::DeniedOn::' , WithdrawnOn = '::WithdrawnOn::' , BorrowerAddress = '::BorrowerAddress::' , BorrowerCity = '::BorrowerCity::' , BorrowerZip = '::BorrowerZip::' , BorrowerCounty = '::BorrowerCounty::' , BorrowerSocSec = '::BorrowerSocSec::' , BorrowerCreditScore = '::BorrowerCreditScore::' , OriginatorIDNumber = '::OriginatorIDNumber::' , Originator = '::Originator::' , Contact = '::Contact::' , OriginatorEmail = '::OriginatorEmail::' , ContactEmail = '::ContactEmail::' , PropertyType = '::PropertyType::' , Product = '::Product::' , Occupancy = '::Occupancy::' , AppraisedValue = '::AppraisedValue::' , LTV = '::LTV::' , LenderName = '::LenderName::' , LenderLoanNumber = '::LenderLoanNumber::' , LockedTerm = '::LockedTerm::' , DocType = '::DocType::' , Escrow = '::Escrow::' , LockedDate = '::LockedDate::' , AppraisalOrderedBy = '::AppraisalOrderedBy::' , AppraisalPaidBy = '::AppraisalPaidBy::' , AttorneyPhone = '::AttorneyPhone::' , AppraiserPhone = '::AppraiserPhone::' , InsAgentPhone = '::InsAgentPhone::' , PayoffsOrderedOn = '::PayoffsOrderedOn::' , AmountofPayoffs = '::AmountofPayoffs::' , ChecksReceivedOn = '::ChecksReceivedOn::' , Condition1 = '::Condition1::' , Condition2 = '::Condition2::' , Condition3 = '::Condition3::' , Condtion4 = '::Condtion4::' , Condition5 = '::Condition5::' , Condition6 = '::Condition6::' , Condition7 = '::Condition7::' , Condition8 = '::Condition8::' , Condition9 = '::Condition9::' , Condition10 = '::Condition10::' , Condition11 = '::Condition11::' , Condition12 = '::Condition12::' , ActiveLoan = '::ActiveLoan::' , UserName = '::UserName::' , Password = '::Password::' , ScheduleOn = '::ScheduleOn::' , Prefers = '::Prefers::' , IntCredit = '::IntCredit::' , Collect = '::Collect::' , HowMuch = '::HowMuch::' , ExpectToPay = '::ExpectToPay::' , ExpectToGet = '::ExpectToGet::' , PayingOff = '::PayingOff::' , Subordination = '::Subordination::' , ClosingConfirmed = '::ClosingConfirmed::' , UpdatedOn = #"& Date() & "# WHERE LoanNumber = ::LoanNumber::" 
fp_sDefault="Status=&LastName=&FirstName=&BorrowerPhone=&BorrowerCellEmail=&LoanAmount=&Purpose=&LockExpiresOn=&OriginalLockTerm=&ClosingDateOn=&InterestRate=&OrigFeePercentage=&OrigFeeDollarAmt=&YieldSpredPremPercentage=&YieldSpreadPremDollarAmt=&UpdatedOn=&AppTakenOn=&RespaMailedOn=&RespaReceivedOn=&Appraiser=&AppraisalOrderedOn=&AppraisalReceivedOn=&SubmittedOn=&StipsReceivedOn=&StipsFaxedOn=&ClearToCloseOn=&Attorney=&TitleOrderedOn=&TitleReceivedOn=&InsuranceAgent=&InsOrderedOn=&InsReceivedOn=&ReadyToScheduleOn=&DeniedOn=&WithdrawnOn=&BorrowerAddress=&BorrowerCity=&BorrowerZip=&BorrowerCounty=&BorrowerSocSec=&BorrowerCreditScore=&OriginatorIDNumber=&Originator=&Contact=&OriginatorEmail=&ContactEmail=&PropertyType=&Product=&Occupancy=&AppraisedValue=<V=&LenderName=&LenderLoanNumber=&LockedTerm=&DocType=&Escrow=&LockedDate=&AppraisalOrderedBy=&AppraisalPaidBy=&AttorneyPhone=&AppraiserPhone=&InsAgentPhone=&PayoffsOrderedOn=&AmountofPayoffs=&ChecksReceivedOn=&Condition1=&Condition2=&Condition3=&Condtion4=&Condition5=&Condition6=&Condition7=&Condition8=&Condition9=&Condition10=&Condition11=&Condition12=&ActiveLoan=&UserName=&Password=&ScheduleOn=&Prefers=&IntCredit=&Collect=&HowMuch=&ExpectToPay=&ExpectToGet=&PayingOff=&Subordination=&ClosingConfirmed=&LoanNumber=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="loanstatus"
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"-->

<!--#include file="../../../_fpclass/fpdbrgn2.inc"-->

</body>

</html>



BeTheBall -> RE: Date Last Updated (4/12/2005 17:10:14)

change this:

UpdatedOn = #"& Date() & "#

to:

UpdatedOn = #"& Now() & "#



steveearlefan -> RE: Date Last Updated (4/12/2005 17:13:05)

It worked. Thanks everyone for the patience and the help. You're HOT!!!!!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.171875