[thelist] Transversing a RecordSet from Multiple Tables

Change: SBU.SBUName
To: states("SBUName")

-----Original Message-----
From: Rob Smith [mailto:rob.smith@thermon.com]


if NOT states.EOF then
   states.movefirst
   if SBU.SBUName <> NULL then   <------------------<<<
     while (SBU.SBUName <> NULL OR NOT states.EOF)
       response.write("<strong>" & SBU.SBUName & "</strong><br>" &
vbCLRF)
	 states.movenext
     wend
   end if
end if