ADODB.Field error '800a0bcd'

Hello,

This -

     
<input name="RetainerValue" type="text" id="RetainerValue" onBlur="this.value = formatField(this);calc('one','two','TotalRetainer')" value="<%If (RsMemberResults.Fields.Item("RetainerValue").Value) <> "" then%><%=(RsMemberResults.Fields.Item("RetainerValue"))%><%Else%><%End If%>" maxlength="8" /></td>

Open in new window


Is resulting in -

ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/retainersurvey.asp, line 94

When the recordset is empty - please advise -

Thanks
garethtnashAsked:
Who is Participating?
 
EyalCommented:
<input name="RetainerValue" type="text" id="RetainerValue" onBlur="this.value = formatField(this);calc('one','two','TotalRetainer')" value="<%If RsMemberResults.BOF Or RsMemberResults.EOF Then%><%Else%><%If (RsMemberResults.Fields.Item("RetainerValue").Value) <> "" then%><%=(RsMemberResults.Fields.Item("RetainerValue"))%><%Else%><%End If%><%End If%>" maxlength="8" /></td>

Open in new window

0
 
SeonyxCommented:
Try testing for the null case:

<%If ((RsMemberResults.Fields.Item("RetainerValue").Value) <> "") or (not IsNull(RsMemberResults.Fields.Item("RetainerValue").Value)) then%>
0
 
garethtnashAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.