ERROR MYSTERY

[gsc123]

I get an error on these catchers but the query is valid?

mySQL="UPDATE products SET products.Price = "&Session("pPrice")&" WHERE (((products.idproduct)="&Session("pIdProduct")&"))"
conntemp.execute(mySQL)

if err.number <> 0 then
response.redirect "pt_supporterror.asp?error="& Server.Urlencode("Error in viewitem: "&err.description)
end if

UPDATE products SET products.Price = 310 WHERE (((products.idproduct)=1562))

 

[PHV]

I get an error
Well, any chance you post the error message ?

 

[gsc123]

Yes its the error Either BOF or EOF has been reached?

 

[gsc123]

and heres another

SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)=1560) AND ((bidhistory.idCustomerBid)=1487)) ORDER BY bidhistory.bidAmount DESC

This query returns 0 because there are no fields, why is this flagging an error?


Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record

 

[gsc123]

Why no matter what I do I still get the error, creashes the function, wont give me a reply?

sql = "SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)="&Session("pIdProduct")&") AND ((bidhistory.idCustomerBid)="&session("idcustomer")&")) ORDER BY bidhistory.bidAmount DESC "
set rsMax = conntemp.execute(sql)
if err.number <> 0 then Response.Write err.Description
'Response.Write sql
pPriceMaxBidMine = rsMax("price")
if not rsMax.EOF or not rsMax.BOF then
processSQLruns = pPriceMaxBidMine
else
processSQLruns = 0
end if

 

[gsc123]

found one porblem

set rsMyMax = conntemp.execute(sql)
if err.number <> 0 then Response.Write err.Description
'Response.Write sql
if not rsMyMax.EOF or not rsMyMax.BOF then
pPriceMaxBidMine = rsMyMax("price")
processSQLruns = pPriceMaxBidMine
else
processSQLruns = 0
end if