Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › ProductPrice & Product MRP

View all replies to this thread

ProductPrice & Product MRP

Thread began 12/30/2014 10:42 am by Kumel | Last modified 12/30/2014 2:18 pm by Kumel | 1248 views | 5 replies

12/30/2014 10:42 amKumel

ProductPrice & Product MRP

I got a Products table which contain many columns. Two of which are ProductPrice & ProductMRP
ProductPrice is selling price or discounted rate.
ProductMRP is actual product price.

Lets call a product as 'x'

x ProductPrice is 100 - selling price
x ProductMRP is 200

ProductPrice & ProductMRP are of type: float(12,2)

All products have ProductPrice & not necessarily ProductMRP. So ProductMRP data is stored as 'NULL'

So now if Product 'x' has ProductPrice as well as ProductMRP displays perfect.

But when Product 'y' has only ProductPrice and ProductMRP has no value which is as 'Null' how do we show only ProductPrice & not shown ProductMRP?

Regards

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.