Home All Groups Group Topic Archive Search About

a memo column not updating



Author
10 May 2005 8:17 PM
Don Wilwol
I wrote a small change management program using ASP, vbscript and an access
database. Everything works great with one exception. When the description
field grows just so big, i can't update it anymore. This happens around
1500+/- characters. I have the column in the table set on the "memo" setting
on the Data type, not text. I've even tried OLE and the same thing happens.
I can create the record way beyond the size I'll ever need, its just
updating it that gives and issue.


The html form uses this code:
<tr>
<td><font face="Arial, Helvetica"> Project Description</font></td></TR>
<tr width="100%"><td width="100%" align="center"><font face="Arial,
Helvetica"><textarea rows="10" cols="100" name=ProjectDiscrip>.....Comments
By: ....Comments or Changes made::-- 
...-------------------------------------------------------------------------------------------------------..
<%=oRS("ProjectDiscrip")%></textarea></font></td>
</tr>

Once it grows to big, I have to delete lines out of the form, and the update
goes through.

Any idea's.........

--
dw

Don Wilwol
Blog - http://spaces.msn.com/members/wilwol/
Web - http://capital.net/~wilwol/dw.htm
DonWilwol(REMO***@yahoo.com

AddThis Social Bookmark Button