access的demo字段限值65k,windows 2k的form每个域的大小限制为100k…………

解决" 超大文本提交的处理"的方法

65k的限制的话，只能换mssql了…………

PRB: Error \"Request Object, ASP 0107 (0×80004005)\" When You Post a Form

The information in this article applies to:

Microsoft Active Server Pages

This article was previously published under Q273482

SYMPTOMS

When you post a large form field, you may receive the following error message:

Error Type:

Request object, ASP 0107 (0×80004005)

The data being processed is over the allowed limit.

In Microsoft Internet Information Server (IIS) 4.0, you may receive the following error message:

Request object error \'ASP 0107 : 80004005\'

Stack Overflow

/projectname/page.asp, line XX

The data being processed is over the allowed limit.

CAUSE

The size limit of each form field that is retrieved in the Request object is 102,399 bytes. The error occurs when you exceed this limit.

RESOLUTION

To resolve this problem, use one of the following methods:

Instead of reading form variable values with the Request.Form collection, use Request.BinaryRead (Request.TotalBytes), and parse the form values from the output of Request.BinaryRead.

Use a File Upload scheme, such as Microsoft Posting Acceptor.

Break the HTML form variables into multiple form variables before you submit the form. The 102,399 byte limit is for each form variable, so you can have multiple form variables of 102,399 characters or less. The following sample code illustrates this: WARNING: ANY USE BY YOU OF THE CODE PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this code \"as is\" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

程序代码 程序代码

<FORM method=post action=LargePost.asp name=theForm onsubmit=\"BreakItUp()\">

<Textarea rows=3 cols=100 name=BigTextArea>A bunch of text…</Textarea>

<input type=submit value=go>

</form>



<SCRIPT Language=JavaScript>

function BreakItUp()

{

//Set the limit for field size.

var FormLimit = 102399



//Get the value of the large input object.

var TempVar = new String

TempVar = document.theForm.BigTextArea.value



//If the length of the object is greater than the limit, break it

//into multiple objects.

if (TempVar.length > FormLimit)

{

document.theForm.BigTextArea.value = TempVar.substr(0, FormLimit)

TempVar = TempVar.substr(FormLimit)



while (TempVar.length > 0)

{

var objTEXTAREA = document.createElement(\"TEXTAREA\")

objTEXTAREA.name = \"BigTextArea\"

objTEXTAREA.value = TempVar.substr(0, FormLimit)

document.theForm.appendChild(objTEXTAREA)



TempVar = TempVar.substr(FormLimit)

}

}

}

</SCRIPT>



The receiving Active Server Page (ASP) page reconstructs the variable:

<%

Dim BigTextArea



For I = 1 To Request.Form(\"BigTextArea\").Count

BigTextArea = BigTextArea & Request.Form(\"BigTextArea\")(I)

Next

%>

—–