Store it as NTEXT, that's what NTEXT was meant for, storing inches... -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 13 March 2006 13:05 To: CF-Talk Subject: RE: Inches
Hi russ, I need it as a string :-) Jenny >>-----Original Message----- >>From: Snake [mailto:[EMAIL PROTECTED] >>Sent: 13 March 2006 12:57 >>To: CF-Talk >>Subject: RE: Inches >> >> >>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:235184 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
