Development wrote: > > I am building a simple app to track patient visits, etc. I need to create a > web tool to let the office admin add fields to the patient table and have > those new fields appear on the patient profile page. > > I have found information on creating tables, dropping tables and altering > fields but I still cannot identify how to just add a field to an existing > table.
ALTER table ADD COLUMN column (type); For details check the manual of your database. > More importantly how do I restructure the patient output page to list > the dynamically changing table data? http://www.kcwebcore.org/blog/index.cfm/2006/8/18/Dynamically-Referencing-Unknown-Query-Columns Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4