We have got a series of type creation tags that actually help evolve the object schema by making the property/method changes and then updating the current object instances automatically. If these are of interest to people we could possibly wrap these up and distribute them.
This sort of object schema change can even be done on a production server. In a dev environment it is great - you can make modifications to the object model all day. -- geoff http://www.daemon.com.au/ Jeremy Cox wrote: > 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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
