Replace Add to Cart with image

I wondered whether there was any way of having the Add to Cart button replaced with a 'sold' button? Most of the things I sell through my site are 'one-offs' so when it is sold it is sold. I just wondered if there was anyway at all of having the add to cart button automatically changed or even stop working once the item was sold?

Yes you could do this pretty easily. Just add a recordset to the page to check to see if the item ID is in the OrderDetails table (identifying that it was sold)... Then you can use the "show region if database is empty" and "show region if database is not empty" based on that recordset finding the item in the sold OrderDetails table.

Ray, sorry meant to reply to this.
I am not using a database so is it still possible to replace the Add to Cart with a Sold image?

Manually? I don't see how you would keep track of when it was sold or not without a database, so the only way to replace the add to cart with a sold image in that case would be to go in and edit the page to do it.

Ray - it's fine. The stuff I sell is for collectors so am not inundated with sales. I had been using PayPal for the cart and had to go in and manually replace the Add to Cart script with a Sold image anyway. It's no big deal but just wondered if there would have been any other way to do it. It's taken me about a year to compile the web site and, tbh, if I had known all the stuff I know now, I would have set the catalogue up as a database - maybe on the next one :)
Thanks for your help anyway

Nick