468,510 Members | 1,736 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

loop recordset

347 100+
I have a database table that contains a set of recordsets call voicetypea to voicetype o and i want to loop through them so that i can list them but avoid gaps for any that have nothing in them

i have tried this
Expand|Select|Wrap|Line Numbers
  1. <% for i = asc("A") to asc("O")
  2.                                   response.Write yaketyRecordset("voicetype(chr(i))" & "<br />")
  3. next %>
does not quite work though

any advice would be appreciated
Jul 16 '10 #1
1 1590
Cant you use a regular if statement:
Expand|Select|Wrap|Line Numbers
  1. <% for i = asc("A") to asc("O")
  2. If voicetype(chr(i)) <> "" Then
  3. response.Write yaketyRecordset("voicetype(chr(i))" & "<br />")
  4. End If
  5. next %>
Oct 14 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Sue Adams | last post: by
8 posts views Thread by Tom | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.