i have a textarea called CommentPCWFlow for the user to key in their comment.


But when i save the form to the database the value stored is only part of the key in value.

Example:
the user key in:
THE TEXT IS YOU.

Data stored in database table:
THE

i set the data type properties as TEXT.
i tried to keyin 123 abc


My code:

<td height="45" valign=top class="style22" style="border-style: solid"><%=textPC2FlowComment%>
                    <input type=hidden textarea name="CommentPCWFlow" value =="<%=textPC2FlowComment%>"></td>

in some other fields i encountered an extra symbol such as " in my stored data in database table.

im using asp, & access & jsp( for validation)
im a newbie in web application programming & ASP.

what should i checked?

Hi,

You're input code looks a little strange. I think it should be:

<input type=textarea name="CommentPCWFlow" value="<%=textPC2FlowComment%>">

You don't need to have a hidden input. You can just write the value in the database directly to the textarea. Hmmm. Plus I haven't seen your code to capture the values or how you're inserting. Its usually something very simple.

Good luck,
Richard

Hi,

this is my coding to pass the value to the database.
this is java script:

rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    if Request.Form("CommentPCWFlow") <> "" then
    rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    else
    rsCommon.Fields("PCWFlowComment") = null
    end if

Are you sure you're using javascript?

You don't need this logic. Its not helping you in any way. No matter what the value is all you're doing it setting
rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow").

rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    if Request.Form("CommentPCWFlow") <> "" then
    rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    else
    rsCommon.Fields("PCWFlowComment") = null
    end if

Try going back to basics. Create a page with one Text Area and post it to your insert page. Look in the database and see what got inserted. Is this an Access database? Post your INSERT query here. Also, this is a .NET forum and your code looks like classic ASP which is another forum.

Thanks.

Thatcoding is in ASP classic.
Yup. its classic ASP + Access database.
ok i'll post it in Classic ASP beginner forum.