CSng

[homeroid]

Hi All,

Im getting some data form the DB and then trying to convert it to another data type:

price = CCur(CSng(retriveRS("iprice&quot * vat))

iprice = 70.87596699

I keep getting a runtime error pointing to CSng.

However when I do CSng(70.87596699) it works.

All I need to do is bring iprice into 2 decimal places ie 70.87

Any help appreciated.

 

[mmcgon]

Change the recordset data to a single, then multiply by vat (which I hope is a single as well). Like this:

price = CCur(CSng(retriveRS("iprice&quot) * vat)

 

[homeroid]

This error was ocurring because the record the code was accessing in the DB was non existant. I traped this by using the IsNull function and taking appropriate action.

Thanks for the tip.

 

[Bullschmidt]

Thanks for letting us know what worked!

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer

http://www.Bullschmidt.com

ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...