simply stripping out the .'s maybe? or is there something Im not getting? tony
<cfset newNumber = replace(form.var1,'.',all)> would do I presume? -----Original Message----- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:30 PM To: CF-Talk Subject: convert string of numbers to numeric? Hi Everyone, I have a problem. I am trying to convert a string of numbers to a real data type, unfortunately without success. I read a CF-Talk board discussion about it, but was unable to get it to work. Can anyone help me. I created an input field: <cfinput type="text" name="var1" validate="float" value="#query.var1#" range="0.00,7.00" required="No" size="4" maxlength="4"> Now I need to convert var1 to a number before sending it through the INSERT (SQL) query on my action page. What am I missing? Thanks --S ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138529 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
