I didnot notice that it has the FROM class, sorry about that.
Can you post on what exactly the ERROR that you see there. And no mention about what database you use(Access/SQL server???). May be you can try executing the output of the following code directly on to your database.
Code:
Response.write "SELECT Max(bid.BidAmount) as MaxBidAmount, " & _
"Max(bid.Timestamp) as LastBidTime from bid " & _
" WHERE ItemID = ' " & rsItems ("ItemID") &" ' "
Response.End
Set rsBid = objCmd.Execute
Looks like the SPACE before and after the
rs(Items("ItemID") or the single quotes itself could be the cause for that. What is the datatype of ItemId on your BID table?
Cheers!
_________________________
- Vijay G
Strive for Perfection