Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. 
Requested operation requires a current record.
/UpdateCustInfo.asp

 <%
	    Dim blnNew
		Select Case Request.QueryString("Action")
		   Case "AddNew"
		      blnNew = True
		   Case "Edit"
		      blnNew = False
		End Select
		
		If blnNew Then
		   Response.Write _
		      "<center><h1>Add New Customer </h1></center>" 
		Else
		   Response.Write _
		      "<center><h1>Edit Customer's Information 
</h1></center>" 
		   
		   Dim rsItem
		   Set rsItem = Server.CreateObject("ADODB.Recordset")
	 	   strSQL = "SELECT * FROM EDI WHERE TraderID = '" & 
Request("TraderID") & "';"
		   rsItem.Open strSQL, objConn, adOpenForwardOnly, 
adLockOptimistic,adCmdText
		End If
      %>   


i think the problem is some where here but not sure the storing process..

Hi Pauline

Do you have more to the script than this?
I can't see where you are writing out your requested results...
Generally if you get an EOF error the record that you are attempting to 
extract does not exist. 

Cheers
Darrell

> Error Type:
A> DODB.Field (0x80020009)
E> ither BOF or EOF is True, or the current record has been deleted. 
R> equested operation requires a current record.
/> UpdateCustInfo.asp

>  <%
	>     Dim blnNew
	> 	Select Case Request.QueryString("Action")
	> 	   Case "AddNew"
	> 	      blnNew = True
	> 	   Case "Edit"
	> 	      blnNew = False
	> 	End Select
	> 	
	> 	If blnNew Then
	> 	   Response.Write _
	> 	      "<center><h1>Add New Customer </h1></center>" 
	> 	Else
	> 	   Response.Write _
	> 	      "<center><h1>Edit Customer's Information 
<> /h1></center>" 
	> 	   
	> 	   Dim rsItem
	> 	   Set rsItem = Server.CreateObject("ADODB.Recordset")
	>  	   strSQL = "SELECT * FROM EDI WHERE TraderID = '" & 
R> equest("TraderID") & "';"
	> 	   rsItem.Open strSQL, objConn, adOpenForwardOnly, 
a> dLockOptimistic,adCmdText
	> 	End If
 >      %>   

> 
i>  think the problem is some where here but not sure the storing 
process..

--0-1979098926-1023335454=:98033
Content-Type: text/plain; charset=us-ascii


 thanks darrell i found the problem alrealdy..
  Darrell <darrell@b...> wrote: Hi Pauline

Do you have more to the script than this?
I can't see where you are writing out your requested results...
Generally if you get an EOF error the record that you are attempting to 
extract does not exist. 

Cheers
Darrell

> Error Type:
A> DODB.Field (0x80020009)
E> ither BOF or EOF is True, or the current record has been deleted. 
R> equested operation requires a current record.
/> UpdateCustInfo.asp

> 	>     Dim blnNew
	> 	Select Case Request.QueryString("Action")
	> 	   Case "AddNew"
	> 	      blnNew = True
	> 	   Case "Edit"
	> 	      blnNew = False
	> 	End Select
	> 	
	> 	If blnNew Then
	> 	   Response.Write _
	> 	      "Add New Customer " 
	> 	Else
	> 	   Response.Write _
	> 	      "Edit Customer's Information 
 /h1>" 
	> 	   
	> 	   Dim rsItem
	> 	   Set rsItem = Server.CreateObject("ADODB.Recordset")
	>  	   strSQL = "SELECT * FROM EDI WHERE TraderID = '" & 
R> equest("TraderID") & "';"
	> 	   rsItem.Open strSQL, objConn, adOpenForwardOnly, 
a> dLockOptimistic,adCmdText
	> 	End If
 >      %>

> 
i> think the problem is some where here but not sure the storing 
process..


---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup