Price Fields

[JoeyT]

Hi!

 

I need a suggestion: I rent and sell DVD's online. I have all products in the product table. When the DVD is a rental, I want to not show anything. Right now the default is $0.00 .

 

- I have removed the price from the field in the table itself

- I have chanegd the type of field from Decimal to Text

- I have changed the default of the price field from DEcimal to Text and allowed for Nulls in any table that had a price field for the rental products.

- I have entered the word "Rental" in the Product_price field

 

All these still return $0.00 in the total fields upon check out. How can I fix it so when there is a rental it shows "Rental" as the price field or even leaves that totals fields blank? (Short of removing the variable from the actual scripts that load the pages cus I still need regular prices to come through.

 

Thanks for any help.

Joe