problem with getting data from database to a textarea

[Na_Sait]

Hi all,

I have ran to a problem not getting data from my SQL databse table to a textarea on my html file. Any help would be appreciated. My java script is as follow:

<TR><Td><FONT COLOR="#000080">Customer Remarks:</Font>
<TD><textarea name="customer_remarks" size=20 maxlength=50
<%if (repair.getCustomerRemarks()==null) %>value=""<%else%>value=<%=repair.getCustomerRemarks()>></textarea>

[MWpro]

Welcome to WebmasterWorld!

To display text inside a textarea, you cannot use the "value" attribute, but must put the contents inside of the textarea tags.

example:

<textarea>
text here
</textarea>

So you would have to fix up that if statement and put it within the textarea tags for it to work.

[Na_Sait]

Thanks for replying, i will take your point.

[Na_Sait]

Thanks a lot MWpro for the solution you gave me. It works perfectly well! one problem arised though is that after i press the delete button for deleting records on the html the 'onFoucus=""' still there. any idea how can i fix it.....

<TR><Td><FONT COLOR="#000080">Customer Remarks:</Font>
<TD><textarea name="customer_remarks" rows="3" cols="30">
<%if (repair.getCustomerRemarks()==null) %>onFocus=""<%else%><%=repair.getCustomerRemarks()%></textarea>

[ajkimoto]

It looks like your onfocus() is outside of the textarea open tag ( ...cols="30"> )

<textarea name="customer_remarks" rows="3" cols="30">
<%if (repair.getCustomerRemarks()==null) %>onFocus=""<%else%><%=repair.getCustomerRemarks()%>

should be:

<textarea name="customer_remarks" rows="3" cols="30"
<%if (repair.getCustomerRemarks()==null) %>onFocus=""<%else%><%=repair.getCustomerRemarks()%> >

or something like that...

ajkimoto

[Na_Sait]

thanks for being there answering my questions. Actully, the code worked only when i changed it to the following format:

<TR><Td><FONT COLOR="#000080">Repair Details:</Font>
<TD><textarea name="repair_details" rows="3" cols="30">
<%if(repair.getRepairDetails()==null){ out.print("");}else{out.print(repair.getRepairDetails());}%></textarea>

Thanks again!