Write and Retrieve text file to/from Database

[henslecd]

I have a multiline textbox that will hold paragraphs of information. I think that I have to write the data to a text file and save the text file to the database, because it doesn't save all of the data when I use the usual request.form("txtArticle") .

Does anyone know of a good article that writes the data to a text file, saves it to a relative path within my project, saves the link to the database, and then retrieves and displays the data on a webpage, inluding all indentions and newlines?

Thanks for the help.

 

[dragonwell]

What type of database is it, and what is the data-type of the field you are trying to insert the long text into. Perhaps the text is just too long to fit in the column size of your database. No need to save to a text file if the database would be more convenient (unless you really want to.)



Greetings,
Dragonwell

 

[henslecd]

It is a SQL 2000 db, and I set the nvarchar length to 2500. It only takes the top line of the multiline textbox. I need to make sure it hold all indentions and newlines, so I definitely don't think that inserting text straight from the textbox will work.

Thanks for your help.