|
The following is my asp code. It works fine on one page.
sub GetData(prod)
strQuery="Select * from contentsofbox where productid=" & prod
rs.Open strQuery, MM_myConn_STRING, 0, 2 ,1
contentDesc=rs("Description")
contentInc=rs("Includes")
UtWt=rs("UnitWeight")
UtPckg=rs("UnitPckg")
colors=rs("colors")
pckgDetails=rs("Packaging")
rs.close()
Set rs = Nothing
end sub
It works fine on one page (I pass 1 as prod). The I use it on another page where I pass 10 as prod. I am getting an error either BOF or EOF is true for
contentDesc=rs("Description")
However when I run the query in Access query builder it works fine and it returns data! So the rs can't be empty. What am I doing wrong?
Thanks!
|