Thats right. if you want to delete the columns of a record you have to update the record and set the columns to null or to whatever the default defined by the database
e.g. Update mytable Set col1 = null , col2 = null Where id = <insert id> Hope that helps Regards Mark Drew On Thu, 9 Dec 2004 18:44:53 -0500, Phillip Perry <[EMAIL PROTECTED]> wrote: > Hi, > > I've read my sql book but I cant find what i'm looking for. According to the > book (as far as my understanding is) you cant specify which columns to > delete, you can only delete the whole record. Is this true? > > Phil > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186929 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
