# How to limite the numbers per row for output of ADODB.Recordset in asp?

**URL:** <https://forum.kirupa.com/t/how-to-limite-the-numbers-per-row-for-output-of-adodb-recordset-in-asp/96913>\
**Category:** Uncategorized\
**Created:** [December 15, 2003, 11:04am UTC](https://forum.kirupa.com/t/how-to-limite-the-numbers-per-row-for-output-of-adodb-recordset-in-asp/96913 "2003-12-15T11:04:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBUH](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@SBUH](https://forum.kirupa.com/u/SBUH)\
**Post date:** [December 15, 2003, 11:04am UTC](https://forum.kirupa.com/t/how-to-limite-the-numbers-per-row-for-output-of-adodb-recordset-in-asp/96913/1 "2003-12-15T11:04:46Z")

</div>

Hello, I have code like following in asp. Then it can list the item I need in one row. Then I found maybe it is better to list them like 3 items per row. Then how to modify the code? Looking forward to receive your comment and hints!! Thanks in advance!

```php

      <%dim rs,conn
Set conn=Server.createObject("ADODB.Connection")
conn.open "xxx"

set rs=Server.CreateObject("ADODB.Recordset")

sql="select distinct (p_id+bg_id) as product from Tshirt_product where order_id='"&id&"'"
rs.Open sql, conn
do until rs.EOF
	response.write(rs("product"))
	Response.write("; ")
	rs.MoveNext
 loop
		rs.close
		conn.close
	%>

```