[thelist] Transversing a RecordSet from Multiple Tables

Tab Alleman Tab.Alleman at realmetros.com
Tue Jun 18 10:37:00 CDT 2002


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

-----Original Message-----
From: Rob Smith [mailto:rob.smith at 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



More information about the thelist mailing list