There was a change made to a table we have where 2 fields that used to be char were made to be decimal. Now, whenever we try to add to or update the table we receive a message that it cannot "convert varchar to numeric". I'm guessing that it has to do with the fact the form is an input type of "text" and therefore the insert won't let it go into the table that way. I tried doing a CONVERT( decimal, form.field), but it still doesn't work. Can someone shed some light on how else to accomplish this? Thanks,
Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
