ASP looping

[Deepiceman]

Hi guys,

I have a database with many fields. One of this field is of type memo
which contains some bullet points seperated by # sign (something along
those lines). What I have is this code which gives me a table with one
row and as many columns in the split array.

************************************************** **********************

<table width="200" border="0">
<% MyStringTerm = rs.Fields("bullet")
if MyStringTerm <> "" Then
MyStringArray = Split (MyStringTerm, "#")
Response.Write "<tr>"
For Each Term In MyStringArray
Response.Write "<td><img width='13' height='13'
src='images/check.gif'></td><td>"
Response.Write Term
Response.Write "</td>"
Next
Response.Write "</tr>"
Else
Response.Write rs.Fields.Item("Bullet").Value
End if%>
</table>

************************************************** **********************

What I want is to change the code so that instead of getting
everything in one row the items are split into a table with 6 columns
and as many rows as required by the data being passed. Each row will
look something like this.
Image --- Data --- Image --- Data --- Image --- Data

Is this possible? The images are going to be the same for the most
part. I am not very good with asp but have to get this to work.
Any help would be appreciated
Thanks in advance
Deep

[Lord Unspecified]

I would put a counter in and whenever it hits 6, reset it and start over.
for example:

************************************************** **********************

<table width="200" border="0">
<% Dim iColCount
iColCount = 1 MyStringTerm = rs.Fields("bullet")
if MyStringTerm <> "" Then
MyStringArray = Split (MyStringTerm, "#")
Response.Write "<tr>"
For Each Term In MyStringArray
Response.Write "<td><img width='13' height='13'
src='images/check.gif'></td><td>"
Response.Write Term
Response.Write "</td>" if iColCount = 6 then
response.write "</tr><tr>"
iColCount = 1
end if Next
Response.Write "</tr>"
Else
Response.Write rs.Fields.Item("Bullet").Value
End if%>
</table>

************************************************** **********************
Mike
"Deepiceman" <de********@yahoo.com> wrote in message
news:f0*************************@posting.google.co m... Hi guys,

I have a database with many fields. One of this field is of type memo
which contains some bullet points seperated by # sign (something along
those lines). What I have is this code which gives me a table with one
row and as many columns in the split array.

************************************************** **********************

<table width="200" border="0">
<% MyStringTerm = rs.Fields("bullet")
if MyStringTerm <> "" Then
MyStringArray = Split (MyStringTerm, "#")
Response.Write "<tr>"
For Each Term In MyStringArray
Response.Write "<td><img width='13' height='13'
src='images/check.gif'></td><td>"
Response.Write Term
Response.Write "</td>"
Next
Response.Write "</tr>"
Else
Response.Write rs.Fields.Item("Bullet").Value
End if%>
</table>

************************************************** **********************

What I want is to change the code so that instead of getting
everything in one row the items are split into a table with 6 columns
and as many rows as required by the data being passed. Each row will
look something like this.
Image --- Data --- Image --- Data --- Image --- Data

Is this possible? The images are going to be the same for the most
part. I am not very good with asp but have to get this to work.
Any help would be appreciated
Thanks in advance
Deep

[Deepiceman]

Thanks a lot lord, added a counter and it works like a charm.

"Lord Unspecified" <lo*************@adelphia.net> wrote in message news:<Nv*******************@news1.news.adelphia.ne t>...

I would put a counter in and whenever it hits 6, reset it and start over.
for example:

************************************************** **********************

<table width="200" border="0">
<%

Dim iColCount
iColCount = 1

MyStringTerm = rs.Fields("bullet")
if MyStringTerm <> "" Then
MyStringArray = Split (MyStringTerm, "#")
Response.Write "<tr>"
For Each Term In MyStringArray
Response.Write "<td><img width='13' height='13'
src='images/check.gif'></td><td>"
Response.Write Term
Response.Write "</td>"

if iColCount = 6 then
response.write "</tr><tr>"
iColCount = 1
end if

Next
Response.Write "</tr>"
Else
Response.Write rs.Fields.Item("Bullet").Value
End if%>
</table>

************************************************** **********************

Mike
"Deepiceman" <de********@yahoo.com> wrote in message
news:f0*************************@posting.google.co m...

Hi guys,

I have a database with many fields. One of this field is of type memo
which contains some bullet points seperated by # sign (something along
those lines). What I have is this code which gives me a table with one
row and as many columns in the split array.

************************************************** **********************

<table width="200" border="0">
<% MyStringTerm = rs.Fields("bullet")
if MyStringTerm <> "" Then
MyStringArray = Split (MyStringTerm, "#")
Response.Write "<tr>"
For Each Term In MyStringArray
Response.Write "<td><img width='13' height='13'
src='images/check.gif'></td><td>"
Response.Write Term
Response.Write "</td>"
Next
Response.Write "</tr>"
Else
Response.Write rs.Fields.Item("Bullet").Value
End if%>
</table>

************************************************** **********************

What I want is to change the code so that instead of getting
everything in one row the items are split into a table with 6 columns
and as many rows as required by the data being passed. Each row will
look something like this.
Image --- Data --- Image --- Data --- Image --- Data

Is this possible? The images are going to be the same for the most
part. I am not very good with asp but have to get this to work.
Any help would be appreciated
Thanks in advance
Deep