Radicore Forum: How To » flexible approach

Home » RADICORE » How To » flexible approach

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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