Hi all, I'm using CFMX and Access 2K (I know, I know). I was collecting some numeric data as "text" just because I was not doing any processing of it (getting averages, etc.), and I wanted to allow for extra characters (e.g., dashes, commas, etc.).
Now that I need to do some math operations on the data, I'm treating the fields as "numeric" both by changing the field type on Access, and by not including the single quotes in the CF queries. My problems: 1 - Now each time a decimal point is followed by zeroes (e.g., "4.00"), my zeroes dissapear from the Access field/table (the number changes to "4"). The last zero dissapears from a number like "4.10" (it changes to "4.1"), but the zero is kept in mid position (e.g., "4.01 stays the same). I tried setting the Access field to "large integer", "two decimal spaces", etc., to no avail. Is there a way to format the CFMX query so that it somehow forces the zeroes into the Access field? 2 - Each time one of the new numeric fields contains a comma and the field gets sent to the database, the system returns a generic error. Again, is there a specific way of formatting that field in the query so that commas are accepted (since they are normal components of a number?). The decimal point does not throw an error, so I would expect the comma to behave in a similar fashion... Thanks in advance for any pointers/ideas/suggestions. Regards, Roberto Perez ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
