objCommand2.Execute
Response.Write Len(Request.Form("txtText"))
The length of the string I was trying to insert into the table turned out to be 1100 characters long. The insert fails to go into the text field. of SQL Server 7.0 table.

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Jpresser,
the size of a parameter is dependant on the underlying datatype not the data you are passing to it. I have have successfully used the 'advarchar' datatype with size 2147483647 as stated above.

amnh:
I tried your example, it did not work with the text type in sql server. It works fine if I use a varchar as the data type.

When I try to insert 900 or more characters into the text type, nothing gets inserted into the field.

The example I left calls a simple stored procedure that just does an insert. For some reason it fails to work when the character string get to the 900 or so characters. It works however, if the data type is varchar, and fails if it is text.

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :)
To start, I want to make sure everyone understands the importance of utilizing p…

Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…