[thelist] Data Shaping and Count

[Brian Cummiskey]

Michele Foster (WizarDev) wrote:

> 
> Where I'm confused, and why I abandoned earlier approaches was my looping
> through the recordset.  Could you, or anyone really, give me some guidance
> on how to approach this.  I was getting lost with my do until, do while, and
> if not end of RS statements.


Michelle:

This is what i usually use:

if not rst.EOF then
	do until rst.eof
		for x = 0 to rst.Fields.count - 1

			' row stuff here...
		next
		rst.movenext
	loop
else
	response.write "No results"
end if