insert column 1

[batrot]

Isn't there some way to insert a new column into a table using ColdFusion?

 

[branko]

I have no experience with Coldfusion, but you could try to use the UPDATE TABLE statement.

But I think I have to raise the question: why? Are you sure it is a wise thing to do?
Well, that is none of my business

Branko

 

[tlbroadbent]

Are you intersted in changing the table structure, inserting data into a column of an existing row in a table or adding a new row of data to a table? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[batrot]

What I was hoping to do was start an app with a set number of columns, which may need to be added to before the table was calculated for numerical values.

Additionally, it'd be easier and less work to be able to insert a column, a new field, without having to open it in Excel or Access, modify the db, save it, and then revise the template for modifying it.

Is this feasible?

 

[tlbroadbent]

Insert is a keyword in SQL that has a specific meaning. Rows are inserted into a table. It appears you want to know how to modify the table structure by adding a column (or field) to the table. The SQL command for adding a columns is the ALTER TABLE command. The following example comes from SQL BOL.

ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL

See SQL BOL for details about ALTER TABLE.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.