|
| |
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
 |
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
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
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?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1315
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Date Last Updated - 4/1/2005 15:40:33
Post your form code too please
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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>
< Message edited by Spooky -- 4/1/2005 21:09:15 >
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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>
< Message edited by Spooky -- 4/1/2005 21:08:32 >
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
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?
< Message edited by Spooky -- 4/1/2005 21:08:55 >
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1315
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
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
Posts: 61
Joined: 7/23/2004
Status: offline
|
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
Posts: 1315
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Date Last Updated - 4/8/2005 16:15:26
Post the code please, sounds like a # is missing or added
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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>
< Message edited by BeTheBall -- 4/8/2005 17:34:47 >
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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>
< Message edited by BeTheBall -- 4/8/2005 17:35:32 >
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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
Posts: 1315
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
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
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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::"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
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>
< Message edited by Spooky -- 4/12/2005 19:25:20 >
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Date Last Updated - 4/12/2005 17:10:14
change this:
UpdatedOn = #"& Date() & "#
to:
UpdatedOn = #"& Now() & "#
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
steveearlefan
Posts: 61
Joined: 7/23/2004
Status: offline
|
RE: Date Last Updated - 4/12/2005 17:13:05
It worked. Thanks everyone for the patience and the help. You're HOT!!!!!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
