If u absolutely must have the " stored in the database, and cannot just stor ethe number then you will have to store it as a sting.
But as has been suggested, only storing the value would be preferable. On your form you can just have the units of measurements in a drop down list, so the user types 11 in the text field and selects INCHES from the drop down. Russ -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 13 March 2006 12:18 To: CF-Talk Subject: RE: Inches All good answers, but won't work for me ... should i use replace function perhaps ? >>-----Original Message----- >>From: Jeff Garza [mailto:[EMAIL PROTECTED] >>Sent: 13 March 2006 11:44 >>To: CF-Talk >>Subject: RE: Inches >> >> >>I'd create an additional column to hold the unit of measure information.. >>You could take it a step further and create an extra table to hold the >>UOM information and just store the PK value in your products table... >> This way >>the only values you hold in the size field would be an interger (or >>decimal) value. >> >>Just a thought, >> >>Jeff >> >>-----Original Message----- >>From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] >>Sent: Monday, March 13, 2006 4:33 AM >>To: CF-Talk >>Subject: Inches >> >>Hi all, >> >>Got a form to enter product size info that needs to take inches, ie 22" >> >>How do I get this value into MSQL and then display it please? >> >>Thanks, Jenny >> >>-- >>No virus found in this outgoing message. >>Checked by AVG Free Edition. >>Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: >>10/03/2006 >> >> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235182 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
