On Monday, Jun 9, 2003, at 22:07 US/Pacific, Emmet McGovern wrote:
> Im building a car database for someone and they want to be able to add
> dynamic options with options in their web admin so they can select
> these
> when adding new cars.
Add a three column table:
car_id - id of car to which this applies
name - name of attribute
value - string value of attribute
This would allow them to specify as many name/value pairs as they want
for each car.
You could implement this in memory in CF as a struct and then save all
the key/value pairs to the database table.
Sean A Corfield -- http://www.corfield.org/blog/
"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
