why dont this work. function

[gsc123]

Function pPriceMaxBidNotMine()
'get the highest bid for this item not belonging to me
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)
pPriceMaxBidNotMine = rsMax("price")
rsMax = Nothing
End Function

Response.write " my bid = "&pPriceMaxBidNotMine()

 

[timfoster]

What do you get back from the query?

 

[gsc123]

This was the problem

rsMax = Nothing

 

[vicvirk]

what did you do to fix it? Do you know what was wrong with that line? If you don't know, do you want to know what was wrong with it, why you sould keep it and how to fix it?

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc