When for ex. somebody writes something in the textarea and if they press Return (on the keyboard) in the textarea everything seems OK. But in the database "Returns" are gone and when you retrieve data from the database "Returns" are gone.
I know that if i write html code in the textarea everything is ok - "Return" is there. I use Mysql database so maybe there is something wrong with settings or maybe when i select data from the database.
I am pretty new at all of this but I have managed to create a interface (dreamweaver, vbscript, access) so that a few of my writers for the web site can log in and submit there text. The question is, how can they (or what do I have to do) place CR and Paragraphs in there content. It seems as thought the Access DB ignores any manual CR that is entered during input. (just like in this input box)
I just pressed the ENTER key twice to get to hear but if I do that in my input box that does not happen.
Also, is there any tutorials that could show me how to place buttons like the ones above this input box so they could put in images along with their text.
This is the code I've written (based on kbogart's suggestions) ....
View Replies View RelatedI’m trying to allow large amounts of text, like up to 6 pages (many paragraphs) of text to be inputted into textarea that then sends off thru email.
When I receive the email, all the paragraphs that I’ve submitted become 1 big long paragraph.
I tried wrap attribute but it does nothing.
Is it possible to receive a paragraph by paragraph by using textarea?
I'm inserting data into my SQL server database via an ASP/HTML form. I have a textarea in the form where the user can enter content and I want to maintain any new paragraphs entered - however, when i insert the content into the database and reproduce it on another page, the spacing is lost and all the content is displayed in one paragraph. Is there a simple way to get round this issue?
The column on the database is set up as Type - Text (size 16).
Access Database
Field required = no
for i = 0 to 2
arrParap(i) = MakeSafe(Request.Form("ppara_text"&cstr(i+1)),2400)
arrImgp(i) = MakeSafe(Request.Form("pimage"&cstr(i+1)),50)
arrImgpPos(i) = MakeSafe(Request.Form("pimgpos"&cstr(i+1)),50)
if len(arrParap(i)) > 0 then
strQp1 = "INSERT INTO paragraphs(para_page, paratext, paraimage, imgposition)"
strQp1 = strQp1 & "VALUES ('" & objRS1("Subcateg_id") & "', '" _
& arrParap(i) & "', '" _
& arrImgp(i) & "', '" _
& arrImgpPos(i) & "')"
objConn.Execute strQp1
End If
result
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Field 'paragraphs.paraimage' cannot be a zero-length string. /content-builder/admin/pageadd.asp, line 53