drop down

[fmardani]

running
cboTerm.Items.Add(oDR.Item("Term"))
produces the error: System.IndexOutOfRangeException

ps. the field Term is an Integer field in sql server 2000.

any ideas please?
Thanks

[PeteD]

This would happen if oDR.Item("Term") does not exist

[fmardani]

Hi,
yes, it does exist because this is the query that I am using...
thanks

SELECT
DISTINCT(Term)
FROM
CDS_CurveSpreadData
ORDER BY
Term

[PeteD]

So if you use:

If Not oDR.Item("Term") Is Nothing Then
cboTerm.Items.Add(oDR.Item("Term"))
End If

then this also fails?

[fmardani]

yes, that fails too.
the error again is: System.IndexOutOfRangeException

Thanks

[PeteD]

Are you perhaps adding the same item twice?

[fmardani]

problem solved. thanks