Nick......try using the alter table, like: <cfquery name="alterable"> ALTER TABLE Vendors ADD vendor_phone char(20) </cfquery>
HTH Bob -----Original Message----- From: nick way [mailto:[EMAIL PROTECTED] Sent: Sunday, October 15, 2006 1:20 PM To: CF-Newbie 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 in 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-Newbie/message.cfm/messageid:2132 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
