Hi to all,

I have some problem plz see that and tell me if u found any fault

when i run this script i found the error of "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."


and the Code

<%
Dim i,sql,masID
sql = "Select * From Products Where Ishotpick='1' "
Set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql,cn,2
%>
<tr>
<%
Do While Not rs.EOF
%>
<%
Dim sql11
sql11 = "Select * From ProductAttributes Where ProductID="&rs("ProductID")
response.Write(sql11) // When we Print this query its running fine
Set rs11 = server.CreateObject ("ADODB.Recordset")
rs11.Open sql11,cn,2
if rs11.eof then
response.Write "Empty"
else
response.Write "Some Data Found" // this line execute (means data found)
end if
response.Write rs11("ProductID") // if i want to print this valid varibale value then error occure
%>
<%
rs.MoveNext()
if rs.EOF then
Exit Do
End if
Loop
%>

and which line does it error out on ?

I think you're using the wrong recordset to spit out your productID. Change the line

response.Write rs11("ProductID") // if i want to print this valid varibale value then error occure

to

response.Write rs("ProductID") // if i want to print this valid varibale value then error occure

Let me know if that fixes the problem.

This line doesnt look right either:
if rs11.eof then

Should be
if sql11.eof then
???
Right

Dan

This line doesnt look right either:
if rs11.eof then

Should be
if sql11.eof then
???
Right

No - sql11 is a string variable simply containing the SQL Statement.

Try changing this:
if rs11.eof then

to this
if rs11.bof and rs11.eof then

If there is key relationship between both tables, you should use sql's INNER JOIN, which will return the results for both tables in one recordset, like this:

SELECT products.*,ProductAttributes.* FROM products INNER JOIN ProductAttributes ON products.productID = ProductAttributes.productID WHERE Ishotpick='1'



And you dont need the If statement if you remove the Do...Loop and replace it with While....wend, , ie.

while (not rs.EOF)

...stuff....

Rs.movenext
Wend

you've check for rs11.eof but you still put response.Write rs11("ProductID") outside of that check. If there is no info to show you will get an error. Also try rs11.movefirst and then iterate through your records. Also I don't see why

if rs.EOF then
Exit Do
End if

that is needed. You've already checked for this condition at the beginning of the loop.