|
| |
|
|
nettop
Posts: 212
Joined: 2/9/2004
Status: offline
 |
'Record is too large' DRW update error - 4/22/2004 2:33:33
I am getting an error on a DRW update page as follows:
Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Record is too large.
Number: -2147467259 (0x80004005)
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.
THANKS, TIM
|
|
|
|
nettop
Posts: 212
Joined: 2/9/2004
Status: offline
|
RE: 'Record is too large' DRW update error - 4/22/2004 9:04:12
Here is the Query string:
<!--#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 Results WHERE ID = ::ID::"
fp_sDefault="ID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="listings"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&_1_description_and_price=202&Business_name=202&Street_Address=202&City=202&State=202&Zip=202&Type=202&_2_Area=202&Detailed_Description=203&Ownership_Structure=202&_4_Employees=202&_5_Year_Established=202&_6_Seats=202&_7_Parking=202&_8_Licenses_Required=202&_9_Hrs_Open=202&_10_Sq_Ft_Size=202&_11_Lease_Term=202&_12_Lease_Options=202&_13_Base_Rent=202&_14_Last_Years_Annual_Gross=202&_15_Annual_Adjusted_Net_Profit=202&_16_COGS=202&_17_Inventory=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&Misc_1=202&Misc_2=202&Misc_3=203&Misc_4=3&Operation_Desc_1=202&MiscO9=202&MiscO10=202&Payroll_detailF4=202&Misc1F8=202&Misc2F9=202&Misc3F10=202&Misc_31=203&photo1_sm=202&photo1_lg=202&photo2_sm=202&photo2_lg=202&photo3_sm=202&photo3_lg=202&photo4_sm=202&photo4_lg=202&photo5_sm=202&photo5_lg=202&photo6_sm=202&photo6_lg=202&photo7_sm=202&photo7_lg=202&photo8_sm=202&photo8_lg=202&Owners_First_Name=202&Owners_Last_Name=202&Owners_Mailing_Address=202&Owners_City=202&Owners_State=202&Owners_Zip=202&Owners_Home_Phone=202&Owners_Cell_Phone=202&Owners_Fax=202&Owners_Email1=202&Owners_Email2=202&Area=202&Misc_5=202&"
fp_iDisplayCols=70
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
Then, there are all of the data fields, 70 of them.
Then, here's the last field and the closing inc file:
<td><b><font size="2">Timestamp:</font></b></td>
<td> <input type="TEXT" name="Timestamp" size="19" value="<%=FP_FieldHTML(fp_rs,"Timestamp")%>"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value=" OK "><input type="reset" value=" Reset "></td>
</tr>
</table>
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
</form>
<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
| |
|
|
|
nettop
Posts: 212
Joined: 2/9/2004
Status: offline
|
RE: 'Record is too large' DRW update error - 4/22/2004 9:06:37
Here is the SQL on the update.asp page:
<!--#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 Results SET _1_description_and_price = '::_1_description_and_price::' , Business_name = '::Business_name::' , Street_Address = '::Street_Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , Type = '::Type::' , _2_Area = '::_2_Area::' , Detailed_Description = '::Detailed_Description::' , Ownership_Structure = '::Ownership_Structure::' , _4_Employees = '::_4_Employees::' , _5_Year_Established = '::_5_Year_Established::' , _6_Seats = '::_6_Seats::' , _7_Parking = '::_7_Parking::' , _8_Licenses_Required = '::_8_Licenses_Required::' , _9_Hrs_Open = '::_9_Hrs_Open::' , _10_Sq_Ft_Size = '::_10_Sq_Ft_Size::' , _11_Lease_Term = '::_11_Lease_Term::' , _12_Lease_Options = '::_12_Lease_Options::' , _13_Base_Rent = '::_13_Base_Rent::' , _14_Last_Years_Annual_Gross = '::_14_Last_Years_Annual_Gross::' , _15_Annual_Adjusted_Net_Profit = '::_15_Annual_Adjusted_Net_Profit::' , _16_COGS = '::_16_COGS::' , _17_Inventory = '::_17_Inventory::' , Remote_computer_name = '::Remote_computer_name::' , User_name = '::User_name::' , Browser_type = '::Browser_type::' , [Timestamp] = '::Timestamp::' , Misc_1 = '::Misc_1::' , Misc_2 = '::Misc_2::' , Misc_3 = '::Misc_3::' , Misc_4 = ::Misc_4:: , Operation_Desc_1 = '::Operation_Desc_1::' , MiscO9 = '::MiscO9::' , MiscO10 = '::MiscO10::' , Payroll_detailF4 = '::Payroll_detailF4::' , Misc1F8 = '::Misc1F8::' , Misc2F9 = '::Misc2F9::' , Misc3F10 = '::Misc3F10::' , Misc_31 = '::Misc_31::' , photo1_sm = '::photo1_sm::' , photo1_lg = '::photo1_lg::' , photo2_sm = '::photo2_sm::' , photo2_lg = '::photo2_lg::' , photo3_sm = '::photo3_sm::' , photo3_lg = '::photo3_lg::' , photo4_sm = '::photo4_sm::' , photo4_lg = '::photo4_lg::' , photo5_sm = '::photo5_sm::' , photo5_lg = '::photo5_lg::' , photo6_sm = '::photo6_sm::' , photo6_lg = '::photo6_lg::' , photo7_sm = '::photo7_sm::' , photo7_lg = '::photo7_lg::' , photo8_sm = '::photo8_sm::' , photo8_lg = '::photo8_lg::' , Owners_First_Name = '::Owners_First_Name::' , Owners_Last_Name = '::Owners_Last_Name::' , Owners_Mailing_Address = '::Owners_Mailing_Address::' , Owners_City = '::Owners_City::' , Owners_State = '::Owners_State::' , Owners_Zip = '::Owners_Zip::' , Owners_Home_Phone = '::Owners_Home_Phone::' , Owners_Cell_Phone = '::Owners_Cell_Phone::' , Owners_Fax = '::Owners_Fax::' , Owners_Email1 = '::Owners_Email1::' , Owners_Email2 = '::Owners_Email2::' , Area = '::Area::' , Misc_5 = '::Misc_5::' WHERE (ID = ::ID::)"
fp_sDefault="_1_description_and_price=&Business_name=&Street_Address=&City=&State=&Zip=&Type=&_2_Area=&Detailed_Description=&Ownership_Structure=&_4_Employees=&_5_Year_Established=&_6_Seats=&_7_Parking=&_8_Licenses_Required=&_9_Hrs_Open=&_10_Sq_Ft_Size=&_11_Lease_Term=&_12_Lease_Options=&_13_Base_Rent=&_14_Last_Years_Annual_Gross=&_15_Annual_Adjusted_Net_Profit=&_16_COGS=&_17_Inventory=&Remote_computer_name=&User_name=&Browser_type=&Timestamp=&Misc_1=&Misc_2=&Misc_3=&Misc_4=0&Operation_Desc_1=&MiscO9=&MiscO10=&Payroll_detailF4=&Misc1F8=&Misc2F9=&Misc3F10=&Misc_31=&photo1_sm=&photo1_lg=&photo2_sm=&photo2_lg=&photo3_sm=&photo3_lg=&photo4_sm=&photo4_lg=&photo5_sm=&photo5_lg=&photo6_sm=&photo6_lg=&photo7_sm=&photo7_lg=&photo8_sm=&photo8_lg=&Owners_First_Name=&Owners_Last_Name=&Owners_Mailing_Address=&Owners_City=&Owners_State=&Owners_Zip=&Owners_Home_Phone=&Owners_Cell_Phone=&Owners_Fax=&Owners_Email1=&Owners_Email2=&Area=&Misc_5=&ID=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="listings"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&_1_description_and_price=202&Business_name=202&Street_Address=202&City=202&State=202&Zip=202&Type=202&_2_Area=202&Detailed_Description=203&Ownership_Structure=202&_4_Employees=202&_5_Year_Established=202&_6_Seats=202&_7_Parking=202&_8_Licenses_Required=202&_9_Hrs_Open=202&_10_Sq_Ft_Size=202&_11_Lease_Term=202&_12_Lease_Options=202&_13_Base_Rent=202&_14_Last_Years_Annual_Gross=202&_15_Annual_Adjusted_Net_Profit=202&_16_COGS=202&_17_Inventory=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&Misc_1=202&Misc_2=202&Misc_3=203&Misc_4=3&Operation_Desc_1=202&MiscO9=202&MiscO10=202&Payroll_detailF4=202&Misc1F8=202&Misc2F9=202&Misc3F10=202&Misc_31=203&photo1_sm=202&photo1_lg=202&photo2_sm=202&photo2_lg=202&photo3_sm=202&photo3_lg=202&photo4_sm=202&photo4_lg=202&photo5_sm=202&photo5_lg=202&photo6_sm=202&photo6_lg=202&photo7_sm=202&photo7_lg=202&photo8_sm=202&photo8_lg=202&Owners_First_Name=202&Owners_Last_Name=202&Owners_Mailing_Address=202&Owners_City=202&Owners_State=202&Owners_Zip=202&Owners_Home_Phone=202&Owners_Cell_Phone=202&Owners_Fax=202&Owners_Email1=202&Owners_Email2=202&Area=202&Misc_5=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<p></p>
<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
| |
|
 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 
k¥ 