Parsing out blank recordsets in dropdown boxes

<i><b>Originally posted by : Terry (rathbun@usa.net)</b></i><br />Hello,<br />Im having trouble with blank fields being displayed in a dropdown box thats displaying recordsets from a table, any suggestions on how to parse them out?<br />Heres the current code i have:<br /><br /><select size=1><br /><% oRs.movefirst<br />do while not oRs.eof<br />%><br /><%totalinst = oRs.fields("InstallUnit") & vbTab & " Qty: " & oRs.fields("TotalInstall")%><br /><option><%=totalinst%><br /><% oRs.movenext<br />loop<br />%></select><br /><br />im concatenating the 2 strings so the dropdown shows the units and qty. any help is greatly appreciated.<br />Thx =)<br />

<i><b>Originally posted by : Venki (nomail@hotmail.com)</b></i><br />check the codings to overcome your problem<br /><br /><br /><br />------------<br />Terry at 12/7/2000 9:51:39 AM<br /><br />Hello,<br />Im having trouble with blank fields being displayed in a dropdown box thats displaying recordsets from a table, any suggestions on how to parse them out?<br />Heres the current code i have:<br /><br /><select size=1><br /><% oRs.movefirst<br />do while not oRs.eof<br />%><br /><br /><%if not isnull(ORs.fields("Installuni") then<br />totalinst = oRs.fields("InstallUnit") & vbTab & " Qty: " & oRs.fields("TotalInstall")%><br /><option><%=totalinst%><br /><br /><%end if <br />oRs.movenext<br />loop<br />%></select><br /><br />im concatenating the 2 strings so the dropdown shows the units and qty. any help is greatly appreciated.<br />Thx =)<br />