Ouch! Pain! Suffering! Steve ___________________________________________________________________ | Stephen Collins, Technical Consultant - ACIS (www.acis.com.au) | | Macromedia Certified ColdFusion 5 Developer | | Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722 | | [EMAIL PROTECTED] [EMAIL PROTECTED] | | ICQ UIN : 56321783 Yahoo! : trib | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~oOOo~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| | Are you building your best Body-for-LIFE? | | www.bodyforlife.com | |___________________________________________________________________|
-----Original Message----- From: Jeremy Cox [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 March 2002 2:38 PM To: Spectra-Talk Subject: Changing type properties Got an interesting one for you. Background: I was having a problem with a few objects in that the properties table was not being updated when the object was modified. As it turned out, the associated property definition was a char datatype and the value for the property being saved was slightly greater than 255 characters. What I would like to do now is to somehow change the property definition for the type's property from "char" to "longchar". Any ideas on the tidiest way to do this? I was thinking of hacking the type definition via direct SQL to the types table, then clearing out the chardata values in the properties table via direct SQL, and then running Daryl Banttari's objectFixer.cfm over the objects to update the properties table (longchardata fields). But I'm not sure if there is any implications in doing this. The property is both searchable and indexed. TIA for any suggestions. Cheers, Jeremy Cox ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
