Im assuming you mean MS Access since you said upload the db and 'yes/no' data type. This should do it.
Alter table mytablename add column newcolumnname yesno; -----Original Message----- From: nick way [mailto:[EMAIL PROTECTED] Sent: Sunday, October 15, 2006 1:19 PM To: CF-Talk Subject: how to create a new column in an exist ing table without uploading a new db fil e hi there, i often find myself needing to add new columns to a table to my access datasource. currently i choose a quiet time of day, download the db from my live server, quickly open it up and add in my new column, then upload it back to the live server - whilst hoping that a) none of my visitors changed anything during this process and b) that no one exeperinced any errors ....not ideal! is there a way to create new columns in tables (and even to create new tables perhaps) via CF so i dont have to do this downloading / uploading procedure to my mdb documnet (i'm using an access database by the way) i'm thinking something like this??... <cfquery datasource="blah"> CREATE COLUMN name="new_variable" type="yes/no"...? </cfquery> is there such a thing? thank you very much indeed for any assistance you can provide. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
