<div>
The idea of using getrows allows you to use your arrProducts &nbsp;variable throughout the page without ever having to go back to the database. Depending on what you are trying to do, you may be fine not taking the arrProducts and putting it to another variable.
</div>


The idea of using getrows allows you to use your arrProducts  variable throughout the page without ever having to go back to the database. Depending on what you are trying to do, you may be fine not taking the arrProducts and putting it to another variable.

<div>
<div class="content wysiwyg-content">
I have a looping &nbsp;array that outputs all necessary data from table . I need to take that looped array and output it in a single string that I can use later in some other code . <br />
<br />

<pre><code id="code-10-29026426-1">Set Products_cmd = Server.CreateObject (&quot;ADODB.Command&quot;)
Products_cmd.ActiveConnection = dbHistory
Products_cmd.CommandText = &quot;SELECT * FROM organic WHERE isActive=0&quot; 
Products_cmd.Prepared = true

Set Products = Products_cmd.Execute

Dim arrProducts
arrProducts = Products.GetRows()

dim i
For i = 0 to ubound(arrProducts, 2)
   response.write( trim(arrProducts(1,i))+&quot;,&quot; )
next

myNewVar_organic=???</code></pre>
<br />
Thanks in advance
</div>
</div>


I have a looping  array that outputs all necessary data from table . I need to take that looped array and output it in a single string that I can use later in some other code . 

(CODE)

Thanks in advance

convert array into single variable string  classic 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.