Populate textarea with recordset

[jasonhuibers]

I have 10 records in database and I want to populate the textarea box with 1 record after each other?

How can I do this?

 

[foxbox]

???
1 textbox with data from 10 records? 10 textareas from 10 records? 10 columns? 10 rows?
???

 

[ChrisHirst]

Append a vbcrlf (Carriage Return + Line Feed) variable to each record

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

 

[jasonhuibers]

Yes, 10 records into 1 textarea...

Hi ChrisHirst... I Have a loop - how can I append the vbcrlf variable to each record? Can you show me an example?

Basically I am trying to show chat content on the page - but I am using a textarea so I am able to scroll and to have other controls under the textarea.

 

[foxbox]

untested/ pseudocode:

<textarea>
<%
cSQL = "SELECT TOP 10 content FROM chat"
rs.open cSQL, conn
do while not rs.eof
 response.write rs("content") & vbCrLf
 rs.movenext
loop
rs.close
%>
</textarea>

 

[jasonhuibers]

Will that actually work???

 

[foxbox]

there is only one way to found out........
and i presume you are clever enough to define and open a connection etc

 

[wvdba]

foxbox's suggestions should work. i should add that you can make a string that has all the ten records plus a vbcrlf at end of each record then put the whole string in the text area.

<%cSQL = "SELECT TOP 10 content FROM chat"
rs.open cSQL, conn
do while not rs.eof 
   msg = msg & rs("content") & vbCrLf 
   rs.movenext
loop
rs.close%>
<textarea>
response.write msg
</textarea>