Hi there,
I have the below sub running in my asp page, which works fine until null records or returned to the resultset.

How do I prevent this.

sub getExperience(idnum)
     Set RSf = Server.CreateObject("ADODB.Recordset") 
    strSQL = "SELECT * FROM Experience where expertid=" & idnum
    RSf.Open strSQL, Conn 
    RSf.MoveFirst 
    do while not RSf.EOF
	    response.write("<div>&nbsp;</div>")
	    response.write("<div class='moreheader'>")
		  response.write(RSf("experience_date"))
		response.write("</div>")
		 response.write("<div class='morebody'>")
		  response.write(RSf("experience"))
		response.write("</div>")
	RSf.movenext
	loop
   end sub

cheers

Steve

if not rsf.eof or not rsf.bof then 
' do this
end if

or if you don't like negative booleans

if rsf.eof or rsf.bof then 
' do this (no records)
else
' do this with records
end if

Try changing your 'do while' loop to a simple 'while' loop.

while not RSf.EOF
...


With a 'do while' loop, the code is executed once, and then the condition (RSf.EOF) is checked.
in a 'while' loop, the condition is checked before the code is executed.

oh lol. Easy when you see how.
Thanks alot.
Steve