| flexible approach [message #581] |
Tue, 30 January 2007 10:21  |
interop
Messages: 45
Registered: October 2006
|
Member |
|
|
I'm trying to use aspects of the "flexible approach" (http://www.tonymarston.net/php-mysql/control-data.html) to store attributes of my equipment. I have an equipment table, an attribute table (eqp_attrib) and a link table (eqp_data). eqp_data.value is a varchar(255) and I'd like to change the type (for display only) of the eqp_data.value based on the attribute type. My problem is when I want to add a new entry to eqp_data I cannot change the type of the value because I do not know the attribute type being entered. Has anyone encounted and solved a problem like this?
thanks
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
