hi i have a form that collects data form the database to allow the user to 

update thier records. the problem is if they write to much text the page 

won't send to the database  (sql serv 7). the fields are set to 8,000 so 

should be enough . 



the updat form handler sends the data to the database as one long string, 

and is about 2200 characters at the max if any one knows how to split or 

any other way if they have had a problem like this i hould appreciate it 

thanks





karl

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "karl hammett" <karl.hammett@b...>

Subject: [access_asp] javascript in asp





: hi i have a form that collects data form the database to

: allow the user to update thier records. the problem is if

: they write to much text the page won't send to the database

: (sql serv 7). the fields are set to 8,000 so should be enough .

:

: the updat form handler sends the data to the database

: as one long string, and is about 2200 characters at the

: max if any one knows how to split or any other way if

: they have had a problem like this i hould appreciate it

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



{note to moderators: if you think this is outta line, that's OK. Just

reject, and I'll reword it to be less critical}



A) This is an Access list, not an SQL Server list. Wrox has several SQL

Server lists.



B) You haven't posted any relevant code (eg the first question I'd ask is if

you are using GET or POST)



C) You haven't posted any relevant tables structures etc



D) It is not very clear at what point there is a problem because there is a

distinct lack of punctuation in your email, coupled with spelling mistakes

etc.



I'm sorry if this is harsh - I don't mean it to be non-constructive

criticism but if you'd like us to spend time looking at your problem, I

suggest you do us the courtesy of spending some time so as to present your

problem in a manner that doesn't waste ours.



www.adopenstatic.com/personal/help.asp



Cheers

Ken