RE: convert from money to number

Generally though, you want to cast(moneyfield as float) not int. int will strip off the cents... -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:20 PM To: CF-Talk Subject: Re: convert from money to number On Thursday, November 15

Re: convert from money to number

use convert() in the SQL query you use to grab the data On Thu, 15 Nov 2001, Wurst, Keith D. wrote: > hi everyone. im have a sql backend with a field that has the type of > "money". once i get this field into my cf page, i want to them perform math > functions on it (division, addition, etc.) so

RE: convert from money to number

wrap each number in a val() function. It forces numeric conversion Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] "...'If there must be trouble, let it be in my day, that my child may have pea