How can textarea shows value with return

[Jack]

Hello,
<%@ Language=VBScript %>
<%
Response.Write "<FORM name=form1>"
Set shipment_db = Server.CreateObject("ADODB.Connection")
shipment_db.Open "shipment"
Set shipmentTable = shipment_db.Execute("SELECT * FROM shipment WHERE ID
=39")
y=shipmentTable("Specification")
Response.Write "<TEXTAREA rows=4 cols=20 id=textarea1
name=textarea1></TEXTAREA>"
%>
<Script language=JavaScript>
document.form1.textarea1.value="<%=y%>"
</Script>
<%
Response.Write "</FORM>"
%>
shipment is a Microsoft Access's table,Specification is this table's field.
But this field has returns.That is to say
shipmentTable("Specification")="abc
edf
ghi"
textarea1 cannot shows shipmentTable("Specification")'s value.it shows none.
Thank you

 

[Jack]

Thank you,
use newString = replace(oldString,vbcrlf,"<br>")
The textarea can show value.But oldString's return be changed to "<br>".
That is to say:
if oldString="ABC
DEF
GHI"
The textarea shows "ABC<br>DEF<br>GHI".
I wait anyone's help.

 

[Jack]

Thank you,but

newString = split(oldstring,"vbcrlf")

In my computer,this procedure is error.
I wait anyone's help

 

[Ray at]

Why are you assigning the value to the text area using client side code like
that? That defeats half the purpose of ASP.

<%
Set shipment_db = Server.CreateObject("ADODB.Connection")
shipment_db.Open "shipment"
Set shipmentTable = shipment_db.Execute("SELECT * FROM shipment WHERE
ID=39")
y=shipmentTable("Specification")
' http://www.aspfaq.com/show.asp?id=2424
shipmentTable.Close : Set shipmentTable = Nothing
shipment_db.Close : Set shipment_db = Nothing

%>

<FORM name=form1>
<TEXTAREA rows=4 cols=20 id=textarea1 name=textarea1><%=y%></TEXTAREA>
</form>

 

[Randy Rahbar]

newString = split(oldstring,"vbcrlf")

Lose the quotes...
newString = split(oldstring,vbcrlf)

 

[Randy Rahbar]

Ray at home

Microsoft ASP MVP

A little off topic, but... Congrats on the MVP

 

[Ray at]

Thank you very much Randy. :]

Ray at work

A little off topic, but... Congrats on the MVP

 

[Ray at]

True...

Question : What is Microsoft MVP ?

Someone who didn't get enough work done last year because he spent too much
time in newsgroups. :] See here. www.microsoft.com/mvp

Ray at work

 

[Ray at]

http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs Or
better, read the part in the bordered table here.
http://www.mvps.org/about/

Ray at work

How do you become so ?

True...

Question : What is Microsoft MVP ?

Someone who didn't get enough work done last year because he spent too much
time in newsgroups. :] See here. www.microsoft.com/mvp

Ray at work

 

[Jack]

Thank you very much