<div>
Um... the second &quot;rsData.EOF&quot; actually should be &quot;rsData.MoveNext&quot;<br />
<br />
Greets
</div>


Um... the second "rsData.EOF" actually should be "rsData.MoveNext"

Greets

<div>
alssam's code is right but forget &quot;&nbsp;&quot;<br />
string = string &amp;&nbsp;&quot; &quot;&nbsp;&amp; rsData(&quot;desc&quot;)
</div>


alssam's code is right but forget " "
string = string & " " & rsData("desc")

<div>
<div class="content wysiwyg-content">
Greeting,<br />
<br />
I have the following format in a table.<br />
<br />
ID &nbsp; Desc<br />
-- &nbsp; &nbsp;-----<br />
1 &nbsp; &nbsp; this is<br />
2 &nbsp; &nbsp; a<br />
3 &nbsp; &nbsp; test<br />
<br />
what I want to have is a string=&quot;this is a test&quot;. Basically, use the select statement then append the Desc field. &nbsp; the ID can be null or up to any number.<br />
<br />
thanks.<br />
<br />

</div>
</div>


Greeting,

I have the following format in a table.

ID   Desc
--    -----
1     this is
2     a
3     test

what I want to have is a string="this is a test". Basically, use the select statement then append the Desc field.   the ID can be null or up to any number.

thanks.



Appending string in asp

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.