Forums
This topic is locked
Query Error
01 Sep 2001 19:36:31 Alain Uy posted:
when i try to search a record on my query page which is not in the db (or blank query)i get this error, Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/result.asp, line 150
as i have read the result page will still display but without the queried record, or just the result page.. please anyone can help?
Replies
Replied 02 Sep 2001 00:47:33
02 Sep 2001 00:47:33 Viktor Farcic replied:
This error means that there is no records to show or that it's the end or records. Anyway, you should use Show Region server behavior in order to awoid this error message.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
when i try to search a record on my query page which is not in the db (or blank query)i get this error,
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/result.asp, line 150
as i have read the result page will still display but without the queried record, or just the result page.. please anyone can help?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
when i try to search a record on my query page which is not in the db (or blank query)i get this error,
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/result.asp, line 150
as i have read the result page will still display but without the queried record, or just the result page.. please anyone can help?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 03 Sep 2001 01:44:14
03 Sep 2001 01:44:14 Alain Uy replied:
i already did set a show region server behavior but still got that problem
Replied 03 Sep 2001 09:16:34
03 Sep 2001 09:16:34 Viktor Farcic replied:
Either you haven't set 'Show Region' right or you have more than one recordset or... Send your code here so that I can take a closer look.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This error means that there is no records to show or that it's the end or records. Anyway, you should use Show Region server behavior in order to awoid this error message.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
when i try to search a record on my query page which is not in the db (or blank query)i get this error,
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/result.asp, line 150
as i have read the result page will still display but without the queried record, or just the result page.. please anyone can help?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This error means that there is no records to show or that it's the end or records. Anyway, you should use Show Region server behavior in order to awoid this error message.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
when i try to search a record on my query page which is not in the db (or blank query)i get this error,
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/result.asp, line 150
as i have read the result page will still display but without the queried record, or just the result page.. please anyone can help?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>