Re: Database Manipulation and output

[Dan Plesse]

You might have to double check to see if the column was in fact added and
you might have to look at the metadata.

Example
http://www.cfide.org/getColumnLength.html

Shows the bootloader at work and metadata returned as cfquery object for an
access table as a test.


~|
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:250489
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Database Manipulation and output

[Jochem van Dieten]

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