I would suggest you not use user-defined columns but instead you have a table that contains user-defined data. For example, instead of having userdefined1, userdefined2, userdefined3, etc. in your users table, you have a separate table called userFields. Each row would have the user ID and any other fields to describe the user defined field (title, description, etc). Then you'd join the two tables to get the extra fields. Am I making sense?
> -----Original Message----- > From: Eric Dawson [mailto:[EMAIL PROTECTED] > Sent: Friday, March 10, 2006 2:35 PM > To: CF-Talk > Subject: User Defined Data Fields > > Are there any standard approaches I can use to allow users to > define their > own database fields to extend an online database? > > ie > > datatable > id > datafield1 > datafield2 > datafield3 > datafield4 > > datatable-udfield > fieldid > fieldname > > datatable-userdefined > id > fieldid > data > > The user would be able to edit the standard fields and also > create their own > fields for their own use. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235092 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
