loop recordset

[colinod]

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

<% for i = asc("A") to asc("O")
  								response.Write yaketyRecordset("voicetype(chr(i))" & "<br />")
next %>

does not quite work though

any advice would be appreciated

[Hennie JvN]

Cant you use a regular if statement:

<% for i = asc("A") to asc("O")
If voicetype(chr(i)) <> "" Then
response.Write yaketyRecordset("voicetype(chr(i))" & "<br />")
End If
next %>