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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ 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.
