I have the following code for a combo. When i try to populate it from a table[structure is : GateDetails(GD_GateCode,GD_GateDesc,GD_Deleted) ], i get this error: "ADODB.Recordset error '800a0cc1'Item cannot be found in the collection correspondin to the requested name or ordinal"

td><select id=cboGate name=cboGate>
        <%
            'Fetch Gate Names
            set rsTemp = CreateObject("ADODB.Recordset")
            rsTemp.open "Select GD_GateCode from GateDetails where GD_Deleted=0",Conn

            'Load Gate Combo%>
            <%rsTemp.MoveFirst%>
            <%do while rsTemp.EOF=false%>
<option value =<%=rsTemp.Fields("GD_GateCode").Value %>><%'=rsTemp.Fields("GD_GateDesc").Value

%></option>
                <%rsTemp.MoveNext%>
            <%loop%>
            </select>
        </td>

Please help!
Thanks
Ashu

You didn't include the Description field in your SELECT statement. Even if the table contains the column, when you don't select it, you can't use it: There is no need to use <% and %> so much. You can wrap them all in one server side code block:<%
'Fetch Gate Names
Set rsTemp = CreateObject("ADODB.Recordset")
rsTemp.open "SELECT GD_GateCode, GD_GateDesc FROM GateDetails WHERE GD_Deleted=0", Conn

'Load Gate Combo
rsTemp.MoveFirst
Do While rsTemp.EOF = False
  Response.Write("<option value =""" & rsTemp.Fields("GD_GateCode").Value & """>"
  Response.Write(rsTemp.Fields("GD_GateDesc").Value & "</option>")
  rsTemp.MoveNext
loop

This should speed up your page just a little, as the processing engine doesn't have to switch code blocks.

HtH,

Imar




---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.