Error Type: Either BOF or EOF is True
-
I am not sure why I am getting this error if I have included: "IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN". I hate to include the whole code but it may prove necessasry to get a response. It runs OK when I submit an empty value but if I search for something that's not in the database I get the error. See Error and Source Code Below. Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /gregstore/GregStoreMPSearchPage.asp, line 117 Source Code: <% 'Get Search Phrase SearchFor = TRIM( Request( "searchfor" ) ) 'Open database connection Set dbCon = Server.CreateObject( "ADODB.Connection" ) dbCon.Open "GregStore" %> Welcome to Greg's Online Store - Search
Welcome to Greg's Online Store!!
<% 'Get The curent Page pg = TRIM(Request( "pg" )) IF pg = "" THEN pg = 1 SET GOSSearchRS = Server.CreateObject( "ADODB.Re
-
I am not sure why I am getting this error if I have included: "IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN". I hate to include the whole code but it may prove necessasry to get a response. It runs OK when I submit an empty value but if I search for something that's not in the database I get the error. See Error and Source Code Below. Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /gregstore/GregStoreMPSearchPage.asp, line 117 Source Code: <% 'Get Search Phrase SearchFor = TRIM( Request( "searchfor" ) ) 'Open database connection Set dbCon = Server.CreateObject( "ADODB.Connection" ) dbCon.Open "GregStore" %> Welcome to Greg's Online Store - Search
Welcome to Greg's Online Store!!
<% 'Get The curent Page pg = TRIM(Request( "pg" )) IF pg = "" THEN pg = 1 SET GOSSearchRS = Server.CreateObject( "ADODB.Re
why you want to put this condition IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN This condition reads if recordset is not BOF and recordset is EOF then do the execution. If recordset is already EOF the from where u will get the new record. try this IF NOT GOSSearchRS.EOF THEN
cheers, Akhilesh Yadav